[
  {
    "db_id": "car_1",
    "input": "How many car models are produced by each maker? List the count and the maker full name. | select count ( * ) , car_makers.fullname from model_list join car_makers on model_list.maker = car_makers.id group by car_makers.id | Which models are the most popular?",
    "label": "CONFIRM_SQL",
    "output": "select model_list.model from model_list join car_makers on model_list.maker = car_makers.id group by car_makers.id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "Which the least popular?\n | select model_list.model from model_list join car_makers on model_list.maker = car_makers.id group by car_makers.id order by count ( * ) asc | Which companies have three or more models?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) , car_makers.fullname , car_makers.id from model_list join car_makers on model_list.maker = car_makers.id group by car_makers.id having count ( * ) >= 3"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Hi!  Can you tell me how many unique template IDs there are? | select count ( distinct template_id ) from documents | How many of those 12 template IDs are used by more than one document?",
    "label": "CONFIRM_SQL",
    "output": "select count ( template_id ) from documents group by template_id having count ( * ) > 1"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Great!  Can you show me the corresponding document that used each of those template IDs on the list you just provided me? | select document_id from documents group by template_id having count ( * ) > 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks, good bye"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Find the first name of the students who permanently live in the country Haiti. | select students.first_name from students join addresses on students.permanent_address_id = addresses.address_id where addresses.country = 'Haiti' | Please also find the first name of the students who have the cell phone number 09700166582",
    "label": "CONFIRM_SQL",
    "output": "select first_name from students where cell_mobile_number = '09700166582'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Can you show me the last name and address for him? | Do you want his current address or the permanent address? | current address please",
    "label": "CONFIRM_SQL",
    "output": "select students.last_name , addresses.* from students join addresses on students.current_address_id = addresses.address_id where students.cell_mobile_number = '09700166582'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Ok. Can you also give me his email address? | select email_address from students where cell_mobile_number = '09700166582' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you! bye"
  },
  {
    "db_id": "concert_singer",
    "input": "what is the name of the stadium that does not have a concert in year 2014? | select name from stadium except select stadium.name from concert join stadium on concert.stadium_id = stadium.stadium_id where concert.year = 2014 | what is the capacity of Balmoor?",
    "label": "CONFIRM_SQL",
    "output": "select capacity from stadium where name = 'Balmoor'"
  },
  {
    "db_id": "concert_singer",
    "input": "what is the theme of Balmoor? | select concert.theme from stadium join concert on stadium.stadium_id = concert.stadium_id where stadium.name = 'Balmoor' | Thanks!",
    "label": "WELCOME",
    "output": "welcome goodbye"
  },
  {
    "db_id": "dog_kennels",
    "input": "how many female dogs have gone through treatment  | select count ( * ) from dogs where dog_id in ( select dog_id from treatments ) | what are their ages",
    "label": "CONFIRM_SQL",
    "output": "select age from dogs where dog_id in ( select dog_id from treatments )"
  },
  {
    "db_id": "dog_kennels",
    "input": "what is the highest weight of age 2 | select weight from dogs where age = 2 order by weight desc limit 1 | Thanks!",
    "label": "REQUEST_MORE",
    "output": "No problem. Anything more you'd like to ask?"
  },
  {
    "db_id": "course_teach",
    "input": "How many teachers are there? | select count ( * ) from teacher | How many courses do you have?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from course_arrange"
  },
  {
    "db_id": "course_teach",
    "input": "Can you tell me the names of teachers and the number of courses they teach? | select teacher.name , count ( * ) from course_arrange join teacher on course_arrange.teacher_id = teacher.teacher_id group by teacher.name | Sure. Can you tell me the age of each teacher?",
    "label": "CONFIRM_SQL",
    "output": "select name , age from teacher"
  },
  {
    "db_id": "battle_death",
    "input": "What is the Latin commander of Battle of Serres? | select latin_commander from battle where name = 'Battle of Serres' | What is the result of 31st January 1206?",
    "label": "CONFIRM_SQL",
    "output": "select result from battle where date = '31 January 1206'"
  },
  {
    "db_id": "battle_death",
    "input": "Who is the Bulgarian commander on June 1205? | select bulgarian_commander from battle where date = 'June 1205' | What is the name of battle who has Latin commander is Baldwin 1?",
    "label": "CONFIRM_SQL",
    "output": "select name from battle where latin_commander = 'Baldwin I'"
  },
  {
    "db_id": "tvshow",
    "input": "No, thanks | how many TV Channels there | select count ( * ) from tv_channel",
    "label": "INFORM_SQL",
    "output": "what is the language of sky music"
  },
  {
    "db_id": "tvshow",
    "input": "select language from tv_channel where series_name = 'Sky Music' | what is the title of id 2.0 | select title from cartoon where id = 2.0",
    "label": "THANK_YOU",
    "output": "thanks"
  },
  {
    "db_id": "car_1",
    "input": "which horsepower is hight? | Can you please clarify your question? | what is the highest horsepower on the table?",
    "label": "CONFIRM_SQL",
    "output": "select horsepower from cars_data order by horsepower desc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "how many cars data on the table? | select count ( * ) from cars_data | how many cylinders on the table?",
    "label": "CONFIRM_SQL",
    "output": "select sum ( cylinders ) from cars_data"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "Which district has the largest number of products? | select district from shop order by number_products desc limit 1 | What is the manager's name of that shop?",
    "label": "CONFIRM_SQL",
    "output": "select manager_name from shop order by number_products desc limit 1"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "How many products did he produce at that shop? | select number_products from shop order by number_products desc limit 1 | Where is the location of that district?",
    "label": "CONFIRM_SQL",
    "output": "select location from shop order by number_products desc limit 1"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "What is the shop ID number? | select shop_id from shop order by number_products desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye."
  },
  {
    "db_id": "world_1",
    "input": "I want to know the average population of all cities please\n | select avg ( population ) from city | And which districts have cities with populations greater than the average?",
    "label": "CONFIRM_SQL",
    "output": "select district from city where population > ( select avg ( population ) from city )"
  },
  {
    "db_id": "world_1",
    "input": "Within these districts, how many cities does each have with a population greater than the average? | select count ( * ) , district from city where population > ( select avg ( population ) from city ) group by district | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "world_1",
    "input": "Can you list all nations whose government is US territory? | select name from country where governmentform = 'US Territory' | Hmm, I also want to know their GNP and population.",
    "label": "CONFIRM_SQL",
    "output": "select gnp , population from country where governmentform = 'US Territory'"
  },
  {
    "db_id": "world_1",
    "input": "Please find out the average GNP and total population of those nations. | select avg ( gnp ) , sum ( population ) from country where governmentform = 'US Territory' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye."
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "How many shops do we have data for? | select count ( * ) from shop | Can you give me their names?\n",
    "label": "CONFIRM_SQL",
    "output": "select * from shop"
  },
  {
    "db_id": "concert_singer",
    "input": "what are the singers name on this list? | select name from singer | Joe Sharp song \"You\" was released in what year?",
    "label": "CONFIRM_SQL",
    "output": "select song_release_year from singer where name = 'Joe Sharp' and song_name = 'You'"
  },
  {
    "db_id": "concert_singer",
    "input": "how many number of concert has Joe Sharp held? | select count ( * ) from singer_in_concert join singer on singer_in_concert.singer_id = singer.singer_id where singer.name = 'Joe Sharp' group by singer.singer_id | ok. what country is Joe sharp from?",
    "label": "CONFIRM_SQL",
    "output": "select country from singer where name = 'Joe Sharp'"
  },
  {
    "db_id": "car_1",
    "input": "Can you list all the continents? | select continent from continents | Okay, now can you list the number of countries belonging to each continent, including the continent id as well?",
    "label": "CONFIRM_SQL",
    "output": "select continents.contid , continents.continent , count ( * ) from continents join countries on continents.contid = countries.continent group by continents.contid"
  },
  {
    "db_id": "car_1",
    "input": "which models are lighter than 3500? | select distinct model_list.model from model_list join car_names on model_list.model = car_names.model join cars_data on car_names.makeid = cars_data.id join car_makers on model_list.maker = car_makers.id where cars_data.weight < 3500 | what is the weight of  BMW?",
    "label": "CONFIRM_SQL",
    "output": "select distinct cars_data.weight from model_list join car_names on model_list.model = car_names.model join cars_data on car_names.makeid = cars_data.id join car_makers on model_list.maker = car_makers.id where model_list.model = 'bmw'"
  },
  {
    "db_id": "car_1",
    "input": "what is the name of the id 2? | Are you asking about the car or the carmaker? | carmaker?",
    "label": "CONFIRM_SQL",
    "output": "select model from car_names where makeid = 2"
  },
  {
    "db_id": "world_1",
    "input": "Hi. How many countries are listed in total? | select count ( * ) from country | Of the 239 countries, how many different forms of government are there among them?",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct governmentform ) from country"
  },
  {
    "db_id": "world_1",
    "input": "What are the 35 different forms of government from the 239 countries listed? | select distinct governmentform from country | Of the 239 countries, how many of them have a Republic government form?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from country where governmentform = 'Republic'"
  },
  {
    "db_id": "world_1",
    "input": "What are the names of the 122 countries that have a Republic government form? | select name from country where governmentform = 'Republic' | Since Latvia is a country with a Republic government form, which languages are spoken there?",
    "label": "CONFIRM_SQL",
    "output": "select countrylanguage.language from country join countrylanguage on country.code = countrylanguage.countrycode where country.name = 'Latvia'"
  },
  {
    "db_id": "flight_2",
    "input": "how many airline's there | select count ( * ) from airlines | what is the name of the usa airline",
    "label": "REQUEST_MORE",
    "output": "What did you mean by \"the name of the USA airline?\""
  },
  {
    "db_id": "flight_2",
    "input": "united sates of america | select airline from airlines where airline = 'United Airlines' | what is the abbreviation of us airways",
    "label": "CONFIRM_SQL",
    "output": "select abbreviation from airlines where airline = 'US Airways'"
  },
  {
    "db_id": "singer",
    "input": "how many  singer there | select count ( * ) from singer | what is the Citizenship of Alice Walton",
    "label": "CONFIRM_SQL",
    "output": "select citizenship from singer where name = 'Alice Walton'"
  },
  {
    "db_id": "singer",
    "input": "how many sales from song id 3 | select sales from song where song_id = 3 | thanks",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "How many courses in this table? | Do you mean the number of the courses with different course ids? | Yes.",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct course_id ) from courses"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What's the name of the course with least number of students of enrollments? | select courses.course_name from courses join student_enrolment_courses on courses.course_id = student_enrolment_courses.course_id group by courses.course_name order by count ( * ) asc limit 1 | How many students in this table?",
    "label": "REJECT",
    "output": "Sorry, I can't answer this question."
  },
  {
    "db_id": "concert_singer",
    "input": "how many concert are presented on the table | select count ( * ) from concert | show the stadium name and the number of concerts in each stadium",
    "label": "CONFIRM_SQL",
    "output": "select stadium.name , count ( * ) from concert join stadium on concert.stadium_id = stadium.stadium_id group by concert.stadium_id"
  },
  {
    "db_id": "concert_singer",
    "input": "what is the capacity of Stark's Park | select capacity from stadium where name = 'Stark s Park' | list out the concert names",
    "label": "CONFIRM_SQL",
    "output": "select concert_name from concert"
  },
  {
    "db_id": "dog_kennels",
    "input": "How many different treatments are there? | select count ( * ) from ( select distinct treatment_type_code from treatments ) | which one is the most expensive?",
    "label": "CONFIRM_SQL",
    "output": "select * from treatments order by cost_of_treatment desc limit 1"
  },
  {
    "db_id": "dog_kennels",
    "input": "And how about the price of the most recent treatment?  | select cost_of_treatment from treatments order by date_of_treatment desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks. Bye!"
  },
  {
    "db_id": "flight_2",
    "input": "hey | hi, how can i help you?  | Find all airlines that have fewer than 200 flights.",
    "label": "CONFIRM_SQL",
    "output": "select airlines.airline from airlines join flights on airlines.uid = flights.airline group by airlines.airline having count ( * ) < 200"
  },
  {
    "db_id": "flight_2",
    "input": "which ones are London bound? | Sorry, This question is not answerable by the table information. You can ask what country is their destination.  | what country is their destination of the first three?",
    "label": "CONFIRM_SQL",
    "output": "select airlines.airline , flights.destairport from airlines join flights on airlines.uid = flights.airline group by airlines.airline having count ( * ) < 200 limit 3"
  },
  {
    "db_id": "poker_player",
    "input": "Hello!  Which nationalities are shared by more than one person? | select nationality from people group by nationality having count ( * ) > 1 | Okay.  Thanks for that!  Can you show me all of the people IDs that have Russia as the nationality?",
    "label": "CONFIRM_SQL",
    "output": "select people_id from people where nationality = 'Russia'"
  },
  {
    "db_id": "poker_player",
    "input": "Excellent!  Can you  update this list to show the names of all of the associated individuals? | select people_id , name from people where nationality = 'Russia' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you! Goodbye."
  },
  {
    "db_id": "wta_1",
    "input": "What's the average age of all losers of all matches? | select avg ( loser_age ) from matches | What's the average age of all winners of all matches?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( winner_age ) from matches"
  },
  {
    "db_id": "wta_1",
    "input": "SELECT avg(loser_rank) FROM matches | What are the average minutes of all matches? | select avg ( minutes ) from matches",
    "label": "INFORM_SQL",
    "output": "What was the longest match in minutes?"
  },
  {
    "db_id": "wta_1",
    "input": "select max ( minutes ) from matches | What was the shortest match in minutes? | select min ( minutes ) from matches",
    "label": "THANK_YOU",
    "output": "Thanks!"
  },
  {
    "db_id": "flight_2",
    "input": "how many flights are landing in the city of aberdeen or abilene | select count ( * ) from flights join airports on flights.destairport = airports.airportcode where airports.city like '%Aberdeen%' or airports.city like '%Abilene%' | what is the airport code for the city abilene",
    "label": "CONFIRM_SQL",
    "output": "select airportcode from airports where city like '%Abilene%'"
  },
  {
    "db_id": "museum_visit",
    "input": "what are the name of the museums? | select name from museum | which museums are visited the most?",
    "label": "CONFIRM_SQL",
    "output": "select museum.name from museum join visit on museum.museum_id = visit.museum_id group by visit.museum_id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "museum_visit",
    "input": "can i have the id and name of the museum? | select visit.museum_id , museum.name from museum join visit on museum.museum_id = visit.museum_id group by visit.museum_id order by count ( * ) desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, good bye. "
  },
  {
    "db_id": "tvshow",
    "input": "Which titles were directed by Ben Jones or Brandon Vietti? | select title from cartoon where directed_by = 'Ben Jones' or directed_by = 'Brandon Vietti' | What are their original air dates?",
    "label": "CONFIRM_SQL",
    "output": "select title , original_air_date from cartoon where directed_by = 'Ben Jones' or directed_by = 'Brandon Vietti'"
  },
  {
    "db_id": "tvshow",
    "input": "Who are the writers of these cartoons? | select title , written_by from cartoon where directed_by = 'Ben Jones' or directed_by = 'Brandon Vietti' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Can I get all the documents with 'w' in them | Do you want documents with 'w' in the name or description? | Description pls",
    "label": "CONFIRM_SQL",
    "output": "select * from documents where document_description like '%w%'"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Ok can I get just their names | select document_name from documents where document_description like '%w%' | I need the template ids too oops",
    "label": "CONFIRM_SQL",
    "output": "select document_name , template_id from documents where document_description like '%w%'"
  },
  {
    "db_id": "wta_1",
    "input": "What is the average age of the losers from all matches? | select avg ( loser_age ) from matches | What about the average age of the winners from all matches?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( winner_age ) from matches"
  },
  {
    "db_id": "wta_1",
    "input": "How many winners are left handed? | select count ( * ) from matches where winner_hand = 'L' | What are the names of the winner and loser from the longest match?",
    "label": "CONFIRM_SQL",
    "output": "select winner_name , loser_name from matches where minutes = ( select max ( minutes ) from matches )"
  },
  {
    "db_id": "dog_kennels",
    "input": "Show me all the dogs | do you want to show all the attributes of the dogs? | just show me the names of the dogs",
    "label": "CONFIRM_SQL",
    "output": "select name from dogs"
  },
  {
    "db_id": "dog_kennels",
    "input": "Nice! Tell me which of these dogs are the rarest breed | select name from dogs where breed_code = ( select breed_code from dogs group by breed_code order by count ( * ) asc limit 1 ) | What are the genders of these dogs?",
    "label": "CONFIRM_SQL",
    "output": "select name , gender from dogs where breed_code = ( select breed_code from dogs group by breed_code order by count ( * ) asc limit 1 )"
  },
  {
    "db_id": "dog_kennels",
    "input": "What does the ones and twos mean in the table? | Sorry, I don't know the answer. Please ask me other questions related to the data. | Ok sure. Tell me who treated these dogs",
    "label": "CONFIRM_SQL",
    "output": "select * from treatments"
  },
  {
    "db_id": "dog_kennels",
    "input": "Sorry, could you specify your question, There are all attributes of the dog treatments, which one do you want to show? | Alright! just show me the treatment dates of these dogs | select dogs.name , treatments.date_of_treatment from dogs join treatments on dogs.dog_id = treatments.dog_id where dogs.breed_code = ( select breed_code from dogs group by breed_code order by count ( * ) asc limit 1 )",
    "label": "THANK_YOU",
    "output": "Thanks!"
  },
  {
    "db_id": "pets_1",
    "input": "How many students have a cat pet?  | select count ( * ) from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat' | And what about students that don't have a cat pet?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from ( select stuid from student except select student.stuid from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat' )"
  },
  {
    "db_id": "pets_1",
    "input": "And what are their ids?  | select stuid from student except select student.stuid from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye!"
  },
  {
    "db_id": "museum_visit",
    "input": "What is the name of the visitor who visited both a museum opened before 2009 and a museum opened after 2011? | select visitor.name from visitor join visit on visitor.id = visit.visitor_id join museum on museum.museum_id = visit.museum_id where museum.open_year < 2009 intersect select visitor.name from visitor join visit on visitor.id = visit.visitor_id join museum on museum.museum_id = visit.museum_id where museum.open_year > 2011 | What museum did he visit before 2009?",
    "label": "CONFIRM_SQL",
    "output": "select museum.name from visitor join visit on visitor.id = visit.visitor_id join museum on museum.museum_id = visit.museum_id where museum.open_year < 2009 and visitor.name = ( select visitor.name from visitor join visit on visitor.id = visit.visitor_id join museum on museum.museum_id = visit.museum_id where museum.open_year < 2009 intersect select visitor.name from visitor join visit on visitor.id = visit.visitor_id join museum on museum.museum_id = visit.museum_id where museum.open_year > 2011 )"
  },
  {
    "db_id": "museum_visit",
    "input": "What is the ticket price at the Plaza Museum? | select visit.total_spent / visit.num_of_ticket from visitor join visit on visitor.id = visit.visitor_id join museum on museum.museum_id = visit.museum_id where museum.name = 'Plaza Museum' | How many people visited the plaza museum in 2009?\n",
    "label": "SORRY",
    "output": "Sorry, we do not have information on the number of visits in each year."
  },
  {
    "db_id": "museum_visit",
    "input": "What is the average number of tickets sold at the Plaza Museum? | Sorry, we do not have information on the number of tickets sold at museums. | What is Fernando Gago's membership level?",
    "label": "CONFIRM_SQL",
    "output": "select level_of_membership from visitor where name = 'Fernando Gago'"
  },
  {
    "db_id": "museum_visit",
    "input": "How old is Fernando Gago? | select age from visitor where name = 'Fernando Gago' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "flight_2",
    "input": "what is the source airport for United Airlines?\n | select flights.sourceairport from flights join airlines on airlines.uid = flights.airline where airlines.airline = 'United Airlines' | What are the flight numbers for United Airlines?\n",
    "label": "CONFIRM_SQL",
    "output": "select flights.flightno from flights join airlines on airlines.uid = flights.airline where airlines.airline = 'United Airlines'"
  },
  {
    "db_id": "flight_2",
    "input": "Where is flight 28 going to? | select destairport from flights where flightno = 28 | What about flight 29?\n",
    "label": "CONFIRM_SQL",
    "output": "select destairport from flights where flightno = 29"
  },
  {
    "db_id": "wta_1",
    "input": "hi, what are the names of the players? | select first_name , last_name from players | List the first names of all left hand players please",
    "label": "CONFIRM_SQL",
    "output": "select first_name , last_name from players where hand = 'L'"
  },
  {
    "db_id": "flight_2",
    "input": "How many United Airlines flights go to the city called Aberdeen? | select count ( * ) from flights join airports on flights.destairport = airports.airportcode join airlines on airlines.uid = flights.airline where airports.city = 'Aberdeen' and airlines.airline = 'United Airlines' | What other cities does United Airlines go to?",
    "label": "CONFIRM_SQL",
    "output": "select airports.city from flights join airports on flights.destairport = airports.airportcode join airlines on airlines.uid = flights.airline where airports.city != 'Aberdeen' and airlines.airline = 'United Airlines'"
  },
  {
    "db_id": "course_teach",
    "input": "Do you mean the grades of the math courses? | Yes! | Show the name of the teacher for the math course please?",
    "label": "CONFIRM_SQL",
    "output": "select teacher.name from course_arrange join course on course_arrange.course_id = course.course_id join teacher on course_arrange.teacher_id = teacher.teacher_id where course.course = 'Math'"
  },
  {
    "db_id": "course_teach",
    "input": "What grades do they teach? | select course_arrange.grade from course_arrange join course on course_arrange.course_id = course.course_id where course.course = 'Math' | What dates do those courses start?",
    "label": "CONFIRM_SQL",
    "output": "select course.staring_date from course_arrange join course on course_arrange.course_id = course.course_id where course.course = 'Math'"
  },
  {
    "db_id": "poker_player",
    "input": "What is the birth date of the poker player with the lowest earnings? | select people.birth_date from people join poker_player on people.people_id = poker_player.people_id order by poker_player.earnings asc limit 1 | What is the name of the poker player with the lowest earnings?",
    "label": "CONFIRM_SQL",
    "output": "select name from people join poker_player on people.people_id = poker_player.people_id order by poker_player.earnings asc limit 1"
  },
  {
    "db_id": "poker_player",
    "input": "What is the nationality of the poker player with the lowest earnings? | select nationality from people join poker_player on people.people_id = poker_player.people_id order by poker_player.earnings asc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "poker_player",
    "input": "how many poker players are on the table | select count ( * ) from poker_player | how many have height higher than 200",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from people join poker_player on people.people_id = poker_player.people_id where people.height > 200"
  },
  {
    "db_id": "poker_player",
    "input": "what is the average earnings of poker players with height higher than 200\n | select avg ( poker_player.earnings ) from people join poker_player on people.people_id = poker_player.people_id where people.height > 200 | thanks",
    "label": "WELCOME",
    "output": "You are welcome. Good Bye."
  },
  {
    "db_id": "pets_1",
    "input": "Can you show me a list of all of the students IDs for students who have dogs as their pet type? | select student.stuid from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'dog' | Which of those two students have a cat as their pet in addition also having a dog?",
    "label": "CONFIRM_SQL",
    "output": "select student.stuid from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'dog' intersect select student.stuid from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat'"
  },
  {
    "db_id": "pets_1",
    "input": "Thanks! Can you please list the first name and ages of the two students who have dogs as pets? | select student.fname , student.age from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'dog' | Thanks!",
    "label": "REQUEST_MORE",
    "output": "Sure! Anything else?"
  },
  {
    "db_id": "world_1",
    "input": "how many country there | select count ( * ) from country | what is the Country Code of Herat",
    "label": "CLARIFY",
    "output": "Do you mean the country code of city Herat?"
  },
  {
    "db_id": "world_1",
    "input": "yes sir | select countrycode from city where name = 'Herat' | what is the Population of Qandahar",
    "label": "CONFIRM_SQL",
    "output": "select population from city where name = 'Qandahar'"
  },
  {
    "db_id": "tvshow",
    "input": "find id of the tv channels that are from countries with more than two tv channels | select id from tv_channel where country in ( select country from tv_channel group by country having count ( * ) > 2 ) | What is the package option for that channel?",
    "label": "CONFIRM_SQL",
    "output": "select package_option from tv_channel where country in ( select country from tv_channel group by country having count ( * ) > 2 )"
  },
  {
    "db_id": "tvshow",
    "input": "List all series names in alphabetical order | select series_name from tv_channel order by series_name asc | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "dog_kennels",
    "input": "Hello, how many dogs have gone through treatments? | select count ( * ) from dogs where dog_id in ( select dog_id from treatments ) | What is the age of the youngest dog to go through treatment?",
    "label": "CONFIRM_SQL",
    "output": "select min ( age ) from dogs where dog_id in ( select dog_id from treatments )"
  },
  {
    "db_id": "dog_kennels",
    "input": "What about the oldest? | select max ( age ) from dogs where dog_id in ( select dog_id from treatments ) | How about the average age?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( age ) from dogs where dog_id in ( select dog_id from treatments )"
  },
  {
    "db_id": "world_1",
    "input": "LIST THE NATIONS WHICH DO NOT USE ENGLISH | select name from country where name not in ( select country.name from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'English' ) | WHAT IS THE POPULATION OF THE PEOPLE LIVING IN THE NATIONS NOT USING ENGLISH",
    "label": "CLARIFY",
    "output": "did you mean you want the Population of the country  DO NOT USE ENGLISH"
  },
  {
    "db_id": "world_1",
    "input": "YES, THE TOTAL NUMBER OF PEOPLE LIVING IN THE NATIONS THAT DO NOT USE ENGLISH | select name , sum ( population ) from country where name not in ( select country.name from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'English' ) group by name | THANKS",
    "label": "WELCOME",
    "output": "welcome,goodbye"
  },
  {
    "db_id": "car_1",
    "input": "What is the weight of make id 1? | Did you mean to ask for the weight of the car with make id 1? | Yes",
    "label": "CONFIRM_SQL",
    "output": "select cars_data.weight from car_names join cars_data on car_names.makeid = cars_data.id where car_names.makeid = 1"
  },
  {
    "db_id": "car_1",
    "input": "Which year launch the car model  buick? | Did you want to ask for the year on which the car model buick was launched? | Yes",
    "label": "CONFIRM_SQL",
    "output": "select cars_data.year from car_names join cars_data on car_names.makeid = cars_data.id where car_names.model = 'buick'"
  },
  {
    "db_id": "car_1",
    "input": "Find the horsepower of model plymouth. | select cars_data.horsepower from car_names join cars_data on car_names.makeid = cars_data.id where car_names.model = 'plymouth' | For the cars with 4 cylinders, which model has the largest horspower?",
    "label": "CONFIRM_SQL",
    "output": "select car_names.model from car_names join cars_data on car_names.makeid = cars_data.id where cars_data.cylinders = 4 order by cars_data.horsepower desc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "How many different cars on this list were produced in 1974? | select count ( * ) from cars_data where year = '1974' | Can you list just the car IDs produced in 1974 with 8 cylinders?",
    "label": "CONFIRM_SQL",
    "output": "select id from cars_data where year = '1974' and cylinders = '8'"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "I'd like to see Shop names.\n | select name from shop | Which of these are hiring?\n",
    "label": "CONFIRM_SQL",
    "output": "select shop.name from hiring join shop on hiring.shop_id = shop.shop_id group by hiring.shop_id"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "Which shop is hiring the highest number of employees? | do you want the name of the shop ? | Yes",
    "label": "CONFIRM_SQL",
    "output": "select shop.name from hiring join shop on hiring.shop_id = shop.shop_id group by hiring.shop_id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "singer",
    "input": "how many singers are on the table? | select count ( distinct singer_id ) from singer | how many singers have songs with sales more than 300000?",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct singer.name ) from singer join song on singer.singer_id = song.singer_id where song.sales > 300000"
  },
  {
    "db_id": "singer",
    "input": "show distinct names of singers that have songs with sales more than 300000 | select distinct singer.name from singer join song on singer.singer_id = song.singer_id where song.sales > 300000 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "voter_1",
    "input": "who all are the contest | Did you mean  to ask for the names of all contestants? | yes.\n\n",
    "label": "CONFIRM_SQL",
    "output": "select contestant_name from contestants"
  },
  {
    "db_id": "voter_1",
    "input": "can you send the total contestant number? | select count ( contestant_name ) from contestants | how is about the summer?",
    "label": "REJECT",
    "output": "I am sorry, I cannot understand that question. Can you rephrase it?"
  },
  {
    "db_id": "voter_1",
    "input": "how many female contestants are there? | Sorry, I cannot answer that question. | who is the first contestant?",
    "label": "CLARIFY",
    "output": "Did you mean to ask for the name of the contestant with contestant number 1?"
  },
  {
    "db_id": "voter_1",
    "input": "yes can tell me?\n | select contestant_name from contestants where contestant_number = 1 | who is the 2 contestant?",
    "label": "CONFIRM_SQL",
    "output": "select contestant_name from contestants where contestant_number = 2"
  },
  {
    "db_id": "flight_2",
    "input": "hi, list out all airport name | select airportname from airports | show me the total no of flight number",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct flightno ) from flights"
  },
  {
    "db_id": "flight_2",
    "input": "how many country name are there | select count ( distinct country ) from airports | Thanks!",
    "label": "GOOD_BYE",
    "output": "no problem, bye"
  },
  {
    "db_id": "dog_kennels",
    "input": "How many dog breeds are there? | select count ( * ) from breeds | What is the biggest of those dog breeds?",
    "label": "CONFIRM_SQL",
    "output": "select breeds.breed_name from breeds join dogs on breeds.breed_code = dogs.breed_code group by breeds.breed_name order by count ( * ) desc limit 1"
  },
  {
    "db_id": "dog_kennels",
    "input": "How big is the bulldog?\n | select dogs.size_code from breeds join dogs on breeds.breed_code = dogs.breed_code where breeds.breed_name = 'Bulldog' | Thanks!",
    "label": "REQUEST_MORE",
    "output": "You are welcome! Do you want to know more?"
  },
  {
    "db_id": "dog_kennels",
    "input": "What is the name of the breed with the most dogs?\n | select breeds.breed_name from breeds join dogs on breeds.breed_code = dogs.breed_code group by breeds.breed_name order by count ( * ) desc limit 1 | Thanks!\n",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "orchestra",
    "input": "List the name of the conductor with the most years of work. | select name from conductor order by year_of_work desc limit 1 | How many years did Robert Craft work?",
    "label": "CONFIRM_SQL",
    "output": "select year_of_work from conductor where name = 'Robert Craft'"
  },
  {
    "db_id": "orchestra",
    "input": "List the name of the conductor with the least years of work | select name from conductor order by year_of_work asc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "welcome,goodbye"
  },
  {
    "db_id": "world_1",
    "input": "The given codes of country is not speak in English please tell  | Thanks! Which countries do not speak English please tell country names | select name from country where code not in ( select countrycode from countrylanguage where language = 'English' )",
    "label": "AMBIGUOUS",
    "output": "Thanks! Whose government forms Republic"
  },
  {
    "db_id": "world_1",
    "input": "Did you want the names of countries that do not speak English and whose government forms are not Republic? | Thanks! yes | select name from country where code in ( select code from country where governmentform != 'Republic' except select countrycode from countrylanguage where language = 'English' )",
    "label": "THANK_YOU",
    "output": "Thanks!"
  },
  {
    "db_id": "voter_1",
    "input": "Can you tell me what the total number of votes are for the states of \"NY\" and \"CA\"? | select count ( * ) from votes where state = 'NY' or state = 'CA' | Thank you!  Can you provide me with a list of all of the different contestant numbers?",
    "label": "CONFIRM_SQL",
    "output": "select distinct contestant_number from votes"
  },
  {
    "db_id": "voter_1",
    "input": "Awesome!  Can you show me which of the contestants received the most votes and show me that total please? | Sorry, I can't answer the question based on the information in the table. | Okay.  How many vote IDs correspond to contestant number 5?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from votes where contestant_number = '5'"
  },
  {
    "db_id": "poker_player",
    "input": "List all the nationalities in the table with no duplicate records | select distinct nationality from people | List all the nationalities in the table",
    "label": "CONFIRM_SQL",
    "output": "select nationality from people"
  },
  {
    "db_id": "poker_player",
    "input": "Count the number of records where nationality is Russia | select count ( * ) from people where nationality = 'Russia' | Count the number of records where nationality is Bulgaria",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from people where nationality = 'Bulgaria'"
  },
  {
    "db_id": "car_1",
    "input": "list the makers who designed more than 3 car models | select car_makers.* from car_makers join model_list on car_makers.id = model_list.maker group by car_makers.id having count ( * ) > 3 | what is the id of these makers",
    "label": "CONFIRM_SQL",
    "output": "select car_makers.id from car_makers join model_list on car_makers.id = model_list.maker group by car_makers.id having count ( * ) > 3"
  },
  {
    "db_id": "car_1",
    "input": "make a list so that the full name and id of the makers who designed more than 3 car models appear in the same table  | select car_makers.fullname , car_makers.id from car_makers join model_list on car_makers.id = model_list.maker group by car_makers.id having count ( * ) > 3 | thanks",
    "label": "GOOD_BYE",
    "output": "bye"
  },
  {
    "db_id": "car_1",
    "input": "What is the average horsepower?\n | select avg ( horsepower ) from cars_data | Which car has the largest horsepower?",
    "label": "CONFIRM_SQL",
    "output": "select id from cars_data order by horsepower desc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "What is the accelerate of car 39? | select accelerate from cars_data order by horsepower desc limit 1 | Which cars have an accelerate larger than 19.0?\n",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from cars_data where accelerate > 19.0"
  },
  {
    "db_id": "concert_singer",
    "input": "When was the Auditions concert? | select year from concert where concert_name = 'Auditions' | When was the Super bootcamp concert?",
    "label": "CONFIRM_SQL",
    "output": "select year from concert where concert_name = 'Super bootcamp'"
  },
  {
    "db_id": "concert_singer",
    "input": "When was the Home Visits concert?\n | select year from concert where concert_name = 'Home Visits' | Were there any other concerts other than Auditions, Super bootcamp, and Home Visits in 2014 or 2015?",
    "label": "CONFIRM_SQL",
    "output": "select concert_name from concert where year = 2014 or year = 2015"
  },
  {
    "db_id": "concert_singer",
    "input": "How many concerts were there total in 2014 or 2015? | select count ( * ) from concert where year = 2014 or year = 2015 | And how many concerts were there just in 2014?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from concert where year = 2014"
  },
  {
    "db_id": "concert_singer",
    "input": "And how many were there in 2015? | select count ( * ) from concert where year = 2015 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks. bye."
  },
  {
    "db_id": "wta_1",
    "input": "what are the names of the tourneys? | select distinct tourney_name from matches | are there any tourneys that have more than 10 matches?",
    "label": "CONFIRM_SQL",
    "output": "select tourney_name from matches group by tourney_name having count ( * ) > 10"
  },
  {
    "db_id": "wta_1",
    "input": "are these the tourneys with more than 10 matches? | select tourney_name from matches group by tourney_name having count ( * ) > 10 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, good bye. "
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "How many graduates of the school are there? | select count ( * ) from students | Did the 15 graduates graduate at different times?",
    "label": "CONFIRM_SQL",
    "output": "select distinct date_left from students"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Ok. Who graduated the earliest? | What attributes of this student who graduated the earliest would you like to know?  | Please tell me the first name, middle name, and last name.",
    "label": "CONFIRM_SQL",
    "output": "select first_name , middle_name , last_name from students order by date_left asc limit 1"
  },
  {
    "db_id": "flight_2",
    "input": "Can you show the SourceAirport FlightNo 28? | select sourceairport from flights where flightno = '28' | Can you show the City of Airportcode APG?",
    "label": "CONFIRM_SQL",
    "output": "select city from airports where airportcode = 'APG'"
  },
  {
    "db_id": "flight_2",
    "input": "Can Show the names of airports which do not have any flight in and out? | select airportname from airports where airportcode not in ( select sourceairport from flights union select destairport from flights ) | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "wta_1",
    "input": "Find the names of the 3 youngest winners across all matches | select distinct winner_name from matches order by winner_age asc limit 3 | What are points of the 3 youngest winners?",
    "label": "CONFIRM_SQL",
    "output": "select loser_rank_points from matches order by winner_age asc limit 3"
  },
  {
    "db_id": "wta_1",
    "input": "Give me the age of the 3 youngest winners across all matches | select winner_age from matches order by winner_age asc limit 3 | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "network_1",
    "input": "How many friends in this table? | select count ( * ) from friend | Find average grade of the students?",
    "label": "CLARIFY",
    "output": "Do you want me to find the average grade of entries in the Highschooler table?"
  },
  {
    "db_id": "network_1",
    "input": "Yes? | select avg ( grade ) from highschooler | Show names of all high school students?",
    "label": "CONFIRM_SQL",
    "output": "select distinct name from highschooler"
  },
  {
    "db_id": "poker_player",
    "input": "How many poker players are there ? | select count ( * ) from poker_player | How many of them earning more than 300000",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from people join poker_player on people.people_id = poker_player.people_id where poker_player.earnings > 300000"
  },
  {
    "db_id": "poker_player",
    "input": "May i get the name detail of both players | select people.name from people join poker_player on people.people_id = poker_player.people_id where poker_player.earnings > 300000 | Thanks!",
    "label": "GOOD_BYE",
    "output": "bye."
  },
  {
    "db_id": "museum_visit",
    "input": "How many museums do you have? | select count ( * ) from museum | What is the number of staff members in each museum?",
    "label": "CONFIRM_SQL",
    "output": "select num_of_staff from museum"
  },
  {
    "db_id": "museum_visit",
    "input": "Can you tell me the id and the name of the museum, which has the most staff members? | select museum_id , name from museum order by num_of_staff desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Hello!  Can you tell me how many students in total there are on this list? | select count ( * ) from students | Excellent!  Can you show me a list of all 15 students and list their first names, middle names, and last names?",
    "label": "CONFIRM_SQL",
    "output": "select first_name , middle_name , last_name from students"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Thanks!  Can you update this list to include the \"date first registered\" information associated with each student? | select date_first_registered from students | Thanks!",
    "label": "GOOD_BYE",
    "output": "welcome,goodbye"
  },
  {
    "db_id": "pets_1",
    "input": "How many students are there? | select count ( stuid ) from student | How old is the student whose last name is 'Smith’?",
    "label": "CONFIRM_SQL",
    "output": "select age from student where lname = 'Smith'"
  },
  {
    "db_id": "pets_1",
    "input": "Can you plsease include their pets' id too? | select has_pet.petid , age from student join has_pet on student.stuid = has_pet.stuid where student.lname = 'Smith' | Thanks!",
    "label": "WELCOME",
    "output": "welcome,goodbye"
  },
  {
    "db_id": "pets_1",
    "input": "Hello!  Can you show me a list of all of the student IDs for students who have pets? | select distinct student.stuid from student join has_pet on student.stuid = has_pet.stuid | Great!  Can you show me the name (first and last), major and age of those two students?",
    "label": "CONFIRM_SQL",
    "output": "select distinct student.fname , student.lname , student.major , student.age from student join has_pet on student.stuid = has_pet.stuid"
  },
  {
    "db_id": "pets_1",
    "input": "Great!  Now can you filter this list to show me which student(s) have a pet other than a cat? | select fname , lname , major , age from student where stuid not in ( select student.stuid from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat' ) | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, good bye. "
  },
  {
    "db_id": "dog_kennels",
    "input": "how many dogs on the table | select count ( * ) from dogs | what is the age of Kacey",
    "label": "CONFIRM_SQL",
    "output": "select age from dogs where name = 'Kacey'"
  },
  {
    "db_id": "dog_kennels",
    "input": "which dog is highest weight on table | Do you want the name of the dog with the highest weight? | exactly",
    "label": "CONFIRM_SQL",
    "output": "select name from dogs order by weight desc limit 1"
  },
  {
    "db_id": "dog_kennels",
    "input": "what is the size code of BUL | Did you mean the  size codes of dogs with a breed code BUL? | exactly",
    "label": "CONFIRM_SQL",
    "output": "select size_code from dogs where breed_code = 'BUL'"
  },
  {
    "db_id": "world_1",
    "input": "What are the names of the nations with the 3 lowest populations? | select name from country order by population asc limit 3 | Which nation has the largest surface area?",
    "label": "CONFIRM_SQL",
    "output": "select name from country order by surfacearea desc limit 1"
  },
  {
    "db_id": "world_1",
    "input": "Of the 3 nations with the lowest populations, which has the largest surface area? | select name from ( select * from country order by population asc limit 3 ) order by surfacearea desc limit 1 | What is the total population of Antarctica?",
    "label": "CONFIRM_SQL",
    "output": "select population from country where name = 'Antarctica'"
  },
  {
    "db_id": "world_1",
    "input": "Wow!  of the 3 nations with the lowest population, what are the population sizes of the other two besides Antarctica? | select name , population from country order by population asc limit 3 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "network_1",
    "input": "what is the average of friend id?\n | select avg ( friend_id ) from friend | what is the average of grades?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( grade ) from highschooler"
  },
  {
    "db_id": "network_1",
    "input": "what is the highest grade? | select max ( grade ) from highschooler | thanks!",
    "label": "WELCOME",
    "output": "You are welcome. Good bye!"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "how many students are enrolled in a bachelor degree program? | select count ( * ) from students join student_enrolment on students.student_id = student_enrolment.student_id join degree_programs on student_enrolment.degree_program_id = degree_programs.degree_program_id where degree_programs.degree_summary_name = 'Bachelor' | what are their student IDs?",
    "label": "CONFIRM_SQL",
    "output": "select students.student_id from students join student_enrolment on students.student_id = student_enrolment.student_id join degree_programs on student_enrolment.degree_program_id = degree_programs.degree_program_id where degree_programs.degree_summary_name = 'Bachelor'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Who are the students with student id 9? | select distinct students.first_name , students.middle_name , students.last_name from students join student_enrolment on students.student_id = student_enrolment.student_id join degree_programs on student_enrolment.degree_program_id = degree_programs.degree_program_id where students.student_id = 9 | what about id 7?",
    "label": "CONFIRM_SQL",
    "output": "select distinct students.first_name , students.middle_name , students.last_name from students join student_enrolment on students.student_id = student_enrolment.student_id join degree_programs on student_enrolment.degree_program_id = degree_programs.degree_program_id where students.student_id = 7"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "what are the degrees of the students in the bachelor program? | select distinct students.first_name , students.middle_name , students.last_name , degree_programs.degree_summary_name from students join student_enrolment on students.student_id = student_enrolment.student_id join degree_programs on student_enrolment.degree_program_id = degree_programs.degree_program_id where degree_programs.degree_summary_name = 'Bachelor' | what are the different degree descriptions available?",
    "label": "CONFIRM_SQL",
    "output": "select distinct degree_programs.degree_summary_description from students join student_enrolment on students.student_id = student_enrolment.student_id join degree_programs on student_enrolment.degree_program_id = degree_programs.degree_program_id"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "what were the student ids in the bachelor program again? | select distinct students.student_id from students join student_enrolment on students.student_id = student_enrolment.student_id join degree_programs on student_enrolment.degree_program_id = degree_programs.degree_program_id where degree_programs.degree_summary_name = 'Bachelor' | what are those students first name, middle name, and last names?",
    "label": "CONFIRM_SQL",
    "output": "select distinct students.first_name , students.middle_name , students.last_name from students join student_enrolment on students.student_id = student_enrolment.student_id join degree_programs on student_enrolment.degree_program_id = degree_programs.degree_program_id where degree_programs.degree_summary_name = 'Bachelor'"
  },
  {
    "db_id": "car_1",
    "input": "How many makes are there for Chevrolet? | select count ( distinct make ) from car_names where model = 'chevrolet' | How many models are in the list?",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct model ) from car_names"
  },
  {
    "db_id": "car_1",
    "input": "Can you tell me which model has the most makes of cars? | select model from car_names group by model order by count ( distinct make ) desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you! Goodbye."
  },
  {
    "db_id": "course_teach",
    "input": "Can you show me the names of teachers with the course id for the courses they teach? | select teacher.name , course_arrange.course_id from course_arrange join teacher on course_arrange.teacher_id = teacher.teacher_id | Show me the teacher id with the number of courses they teach.",
    "label": "CONFIRM_SQL",
    "output": "select teacher.name , count ( * ) from course_arrange join teacher on course_arrange.teacher_id = teacher.teacher_id group by teacher.name"
  },
  {
    "db_id": "course_teach",
    "input": "I want to know the names of the teachers below age 30. | select name from teacher where age < 30 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks. bye."
  },
  {
    "db_id": "orchestra",
    "input": "When are the auditions?\n | Would you like to know the dates of all performances with the type audition? | Yes that's exactly it",
    "label": "CONFIRM_SQL",
    "output": "select date from performance where type like '%audition%'"
  },
  {
    "db_id": "orchestra",
    "input": "Are three different orchestras performing? | select count ( distinct orchestra_id ) from performance | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you! Goodbye."
  },
  {
    "db_id": "wta_1",
    "input": "Can you show the birth date of player id 200002? | select birth_date from players where player_id = 200002 | What is the first name of player id 200001?",
    "label": "CONFIRM_SQL",
    "output": "select first_name from players where player_id = 200001"
  },
  {
    "db_id": "wta_1",
    "input": "Can you show the codes of countries that have more than 50 players? | select country_code from players group by country_code having count ( * ) > 50 | Thanks!",
    "label": "WELCOME",
    "output": "Welcome and goodbye"
  },
  {
    "db_id": "world_1",
    "input": "which region is the city kabul located | select region from country join city on country.code = city.countrycode where city.name = 'Kabul' | which region is the city herat located",
    "label": "CONFIRM_SQL",
    "output": "select region from country join city on country.code = city.countrycode where city.name = 'Herat'"
  },
  {
    "db_id": "world_1",
    "input": "which region is the city quandahar | select region from country join city on country.code = city.countrycode where city.name = 'Qandahar' | thanks!",
    "label": "GOOD_BYE",
    "output": "bye."
  },
  {
    "db_id": "wta_1",
    "input": "What year has the most number of matches, please? | select year from matches group by year order by count ( * ) desc limit 1 | What year has the least number of matches, please?",
    "label": "CONFIRM_SQL",
    "output": "select year from matches group by year order by count ( * ) asc limit 1"
  },
  {
    "db_id": "wta_1",
    "input": "How many matches were there that year? | select year , count ( * ) from matches group by year order by count ( * ) asc limit 1 | What about in 2016?",
    "label": "CONFIRM_SQL",
    "output": "select year , count ( * ) from matches where year = 2016"
  },
  {
    "db_id": "wta_1",
    "input": "How many of those were played on a hard surface? | select count ( * ) from matches where surface = 'Hard' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks.bye."
  },
  {
    "db_id": "car_1",
    "input": "Did you want the full name of makers and the number? | Yes | How many models does each car maker make?",
    "label": "CONFIRM_SQL",
    "output": "select car_makers.fullname , count ( * ) from car_makers join model_list on car_makers.id = model_list.maker group by car_makers.id"
  },
  {
    "db_id": "car_1",
    "input": "What are all the ids of car makers? | select id from car_makers | And what is their country ids? ",
    "label": "CONFIRM_SQL",
    "output": "select country from car_makers"
  },
  {
    "db_id": "world_1",
    "input": "What is the average percent? | select avg ( percentage ) from countrylanguage | Which code of country has the highest dutch speaking population?",
    "label": "CONFIRM_SQL",
    "output": "select countrycode from countrylanguage where language = 'Dutch' order by percentage desc limit 1"
  },
  {
    "db_id": "world_1",
    "input": "What is the difference in percent to Dutch speaking and Papiamento speaking countries? | What difference do you want? | The difference of the overall percent",
    "label": "CLARIFY",
    "output": "Do you mean average percent?"
  },
  {
    "db_id": "world_1",
    "input": "yes | select avg ( percentage ) from countrylanguage where language = 'Papiamento' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "museum_visit",
    "input": "What is the membership level of Gonzalo Higuaín ? | select level_of_membership from visitor where name = 'Gonzalo Higuaín ' | whose membership level is 5?",
    "label": "CONFIRM_SQL",
    "output": "select name from visitor where level_of_membership = 5"
  },
  {
    "db_id": "museum_visit",
    "input": "how many numbers of persons whose membership level is greater than 5? | select count ( * ) from visitor where level_of_membership > 5 | What is the age of membership level 8?",
    "label": "CONFIRM_SQL",
    "output": "select age from visitor where level_of_membership = 8"
  },
  {
    "db_id": "museum_visit",
    "input": "how many persons who have membership level greater than 4? | select count ( * ) from visitor where level_of_membership > 4 | please sort the names of persons whose age from old to young according to the membership level?",
    "label": "CONFIRM_SQL",
    "output": "select name , level_of_membership from visitor where level_of_membership > 4 order by age desc"
  },
  {
    "db_id": "world_1",
    "input": "Which country speaks the largest number of languages?\n | select country.name from country join countrylanguage on country.code = countrylanguage.countrycode group by country.name order by count ( * ) desc limit 1 | How many languages are spoken in Canada?\n",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from country join countrylanguage on country.code = countrylanguage.countrycode where country.name = 'Canada'"
  },
  {
    "db_id": "world_1",
    "input": "What are the names of those languages? | select countrylanguage.language from country join countrylanguage on country.code = countrylanguage.countrycode where country.name = 'Canada' | Which of these is spoken in the most other countries?",
    "label": "REJECT",
    "output": "Could you ask another question? I cannot answer this."
  },
  {
    "db_id": "world_1",
    "input": "How many countries is Chinese spoken in? | select count ( distinct countrycode ) from countrylanguage where language = 'Chinese' | How many people in Canada speak Chinese?",
    "label": "REJECT",
    "output": "Sorry, we don't have that information."
  },
  {
    "db_id": "world_1",
    "input": "Which countries are in North America? | select name from country where continent = 'North America' | What are the official languages of these countries?",
    "label": "CONFIRM_SQL",
    "output": "select language from countrylanguage where countrycode in ( select code from country where continent = 'North America' ) and isofficial = 'T'"
  },
  {
    "db_id": "world_1",
    "input": "What is the life expectancy in Canada? | select lifeexpectancy from country where name = 'Canada' | Thanks!",
    "label": "WELCOME",
    "output": "Welcome! Goodbye!."
  },
  {
    "db_id": "pets_1",
    "input": "How many students have more than one pet? | select count ( * ) from student join has_pet on student.stuid = has_pet.stuid group by student.stuid having count ( * ) > 1 | What are their names?",
    "label": "CONFIRM_SQL",
    "output": "select student.lname , student.fname from student join has_pet on student.stuid = has_pet.stuid group by student.stuid having count ( * ) > 1"
  },
  {
    "db_id": "pets_1",
    "input": "What gender is Kim Tracy? | select student.lname , student.fname , student.sex from student join has_pet on student.stuid = has_pet.stuid group by student.stuid having count ( * ) > 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks. bye."
  },
  {
    "db_id": "world_1",
    "input": "HOw many regions are there in ASia? | select count ( * ) from ( select region from country where continent = 'Asia' group by region ) | What about in Europe?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from ( select region from country where continent = 'Europe' group by region )"
  },
  {
    "db_id": "world_1",
    "input": "What is the surface area of all 10 of them? | select sum ( surfacearea ) from country where continent = 'Asia' or continent = 'Europe' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks. Bye!"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Hello!  How many template IDs have the description of \"Presentation\"? | select count ( * ) from ref_template_types join templates on ref_template_types.template_type_code = templates.template_type_code where ref_template_types.template_type_description = 'Presentation' | Thank you!  Can you please provide me with the list of the template ids with the template type description of \"Presentation\"?",
    "label": "CONFIRM_SQL",
    "output": "select templates.template_id from ref_template_types join templates on ref_template_types.template_type_code = templates.template_type_code where ref_template_types.template_type_description = 'Presentation'"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Can you provide me with the template type code for these three Temple ids? | select templates.template_id , templates.template_type_code from ref_template_types join templates on ref_template_types.template_type_code = templates.template_type_code where ref_template_types.template_type_description = 'Presentation' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks. bye."
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "How many times at most can a course enrollment result show in different transcripts? | select count ( * ) from transcript_contents group by student_course_id order by count ( * ) desc limit 1 | What are the course enrollment ids for those, please?",
    "label": "CONFIRM_SQL",
    "output": "select student_course_id from transcript_contents group by student_course_id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What is the least number of times of a course enrollment result shows in different transcripts? | select count ( * ) from transcript_contents group by student_course_id order by count ( * ) asc limit 1 | What are the course enrollment ids for those, please?",
    "label": "CONFIRM_SQL",
    "output": "select student_course_id from transcript_contents group by student_course_id order by count ( * ) asc limit 1"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What is the average student course id? | select avg ( student_course_id ) from transcript_contents | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye."
  },
  {
    "db_id": "real_estate_properties",
    "input": "What are the names of the properties with more that one room? | select property_name from properties where room_count > 1 | What are the names of the properties that are either houses or apartments with more than one room?",
    "label": "CONFIRM_SQL",
    "output": "select property_name from properties where property_type_code = 'House' union select property_name from properties where property_type_code = 'Apartment' and room_count > 1"
  },
  {
    "db_id": "real_estate_properties",
    "input": "How many rooms do each of those have? | select property_name , room_count from properties where property_type_code = 'House' union select property_name , room_count from properties where property_type_code = 'Apartment' and room_count > 1 | Are there any apartments with only one room?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from properties where property_type_code = 'Apartment' and room_count = 1"
  },
  {
    "db_id": "real_estate_properties",
    "input": "What is the average agreed selling price of all houses with more than one room? | select avg ( agreed_selling_price ) from properties where property_type_code = 'House' and room_count > 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "thanks.bye."
  },
  {
    "db_id": "flight_2",
    "input": "How many airports are there?\n | select count ( * ) from airports | How many have departing flights?",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct sourceairport ) from flights"
  },
  {
    "db_id": "flight_2",
    "input": "How many will arrive in ASY? | select count ( * ) from flights where destairport like '%ASY%' | Of those flights, how many come from APG and ABR?\n",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from flights where destairport like '%ASY%' and sourceairport like '%APG%' union select count ( * ) from flights where destairport like '%ASY%' and sourceairport like '%ABR%'"
  },
  {
    "db_id": "flight_2",
    "input": "Are there any other flights planned to depart from APG or ABR and what are the flight number of all flights planning to depart?\n | select flightno from flights where ( sourceairport like '%APG%' or sourceairport like '%ABR%' ) and destairport not like '%ASY%' | Thanks!\n",
    "label": "GOOD_BYE",
    "output": "Thank you! bye"
  },
  {
    "db_id": "car_1",
    "input": "how many car makers are their in germany | select count ( * ) from car_makers join countries on car_makers.country = countries.countryid where countries.countryname = 'germany' | what are their names ",
    "label": "CONFIRM_SQL",
    "output": "select car_makers.maker from car_makers join countries on car_makers.country = countries.countryid where countries.countryname = 'germany'"
  },
  {
    "db_id": "car_1",
    "input": "how many cars are their in usa | do you mean car makers?  | yes",
    "label": "CONFIRM_SQL",
    "output": "select count ( car_makers.maker ) from car_makers join countries on car_makers.country = countries.countryid where countries.countryname = 'usa'"
  },
  {
    "db_id": "car_1",
    "input": "what are their names  | select car_makers.maker from car_makers join countries on car_makers.country = countries.countryid where countries.countryname = 'usa' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, good bye. "
  },
  {
    "db_id": "dog_kennels",
    "input": "Can you show the names of owners and the states they live in? | Do you want the first and last names of owners and the states they live in? | Yes please.",
    "label": "CONFIRM_SQL",
    "output": "select first_name , last_name , state from owners"
  },
  {
    "db_id": "dog_kennels",
    "input": "Hmm, I want to know the first and last names of owners and also their emails. | select first_name , last_name , email_address from owners | Can you list the first and last name with emails of owners living in the state whose name contains the substring \"North\"?",
    "label": "CONFIRM_SQL",
    "output": "select first_name , last_name , email_address from owners where state like '%North%'"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "Which cities do more than one employee under age 30 come from? | select city from employee where age < 30 group by city having count ( * ) > 1 | Which cities do more than one employee over age 30 come from?",
    "label": "CONFIRM_SQL",
    "output": "select city from employee where age > 30 group by city having count ( * ) > 1"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "What are the names and ages of all employees over age 30? | select name , age from employee where age > 30 | What are the names and ages of all employees under age 30?",
    "label": "CONFIRM_SQL",
    "output": "select name , age from employee where age < 30"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "What cities are all employees under age 29 from? | select city from employee where age < 29 | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "dog_kennels",
    "input": "How many dog owner's are there? | select count ( * ) from owners | What is the age of the youngest dog?",
    "label": "CONFIRM_SQL",
    "output": "select age from dogs order by age asc limit 1"
  },
  {
    "db_id": "dog_kennels",
    "input": "What is the name of the dog who is 1 year old? | select name from dogs order by age asc limit 1 | Of the 15 owners, what is the name of the owner who owns Evangeline?",
    "label": "CONFIRM_SQL",
    "output": "select owners.first_name , owners.last_name from owners join dogs on owners.owner_id = dogs.owner_id where dogs.name = 'Evangeline'"
  },
  {
    "db_id": "singer",
    "input": "Can you list all the singer ids that aren't present in the song table? | select name from singer where singer_id not in ( select singer_id from song ) | Thanks!",
    "label": "CLARIFY",
    "output": "You should ask at least 3 questions"
  },
  {
    "db_id": "singer",
    "input": "Are there any other singers that don't have a song in the song table? | select name from singer where singer_id not in ( select singer_id from song ) | Thanks!",
    "label": "WELCOME",
    "output": "Welcome. Bye."
  },
  {
    "db_id": "singer",
    "input": "What are the names of the singers who were born in either 1948 or 1949? | select name from singer where birth_year = 1948 or birth_year = 1949 | What is their citizenship?",
    "label": "CONFIRM_SQL",
    "output": "select citizenship from singer where birth_year = 1948 or birth_year = 1949"
  },
  {
    "db_id": "singer",
    "input": "Of the singers that were born in 1948 or 1949, which had the highest net worth?  | select name from singer where birth_year = 1948 or birth_year = 1949 order by net_worth_millions desc limit 1 | Did she have a net worth that was over 30 million?",
    "label": "CONFIRM_SQL",
    "output": "select name , net_worth_millions from singer where birth_year = 1948 or birth_year = 1949 order by net_worth_millions desc limit 1"
  },
  {
    "db_id": "singer",
    "input": "What was the lowest net worth of any singer who was born between 1948 and 1949? | select name from singer where birth_year = 1948 or birth_year = 1949 order by net_worth_millions asc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "Sure. No problem!"
  },
  {
    "db_id": "battle_death",
    "input": "How many battles did not lose any ship with tonnage 225?\n | select count ( * ) from battle where id not in ( select lost_in_battle from ship where tonnage = '225' ) | How many battles did lose a ship with tonnage 225?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from battle where id in ( select lost_in_battle from ship where tonnage = '225' )"
  },
  {
    "db_id": "battle_death",
    "input": "How many ships have a tonnage of 225?\n | select count ( * ) from ship where tonnage = '225' | Do any ships have a tonnage above 225?\n",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from ship where tonnage > '225'"
  },
  {
    "db_id": "battle_death",
    "input": "Who won in the battle when the ship with a tonnage of 225 was sunk? | select result from battle where id in ( select lost_in_battle from ship where tonnage = '225' ) | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "car_1",
    "input": "tell me the FullName of the maker amc | select fullname from car_makers where maker = 'amc' | Tell me CountryName for Countryid  1, 2, and 3.",
    "label": "CONFIRM_SQL",
    "output": "select countryname from countries where countryid = 1 or countryid = 2 or countryid = 3"
  },
  {
    "db_id": "car_1",
    "input": "Tell me the model id made by amc... | select modelid from model_list where model = 'amc' | What are the id and names of the countries which have more than 3 car makers or produce the 'fiat' model ?",
    "label": "CONFIRM_SQL",
    "output": "select countries.countryid , countries.countryname from countries join car_makers on countries.countryid = car_makers.country group by countries.countryid having count ( * ) > 3 union select countries.countryid , countries.countryname from countries join car_makers on countries.countryid = car_makers.country join model_list on car_makers.id = model_list.maker where model_list.model = 'fiat'"
  },
  {
    "db_id": "poker_player",
    "input": "What is the money rank of the poker player with the highest earnings? | select money_rank from poker_player order by earnings desc limit 1 | is that higher than the average money rank?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( money_rank ) from poker_player"
  },
  {
    "db_id": "poker_player",
    "input": "What is the highest earner's people ID? | select people_id from poker_player order by earnings desc limit 1 | What was their best finish?",
    "label": "CONFIRM_SQL",
    "output": "select best_finish from poker_player order by earnings desc limit 1"
  },
  {
    "db_id": "poker_player",
    "input": "How much higher is his earning than the average? | select avg ( earnings ) as earning from poker_player union select max ( earnings ) as earning from poker_player | And what is the highest earning?",
    "label": "CONFIRM_SQL",
    "output": "select earnings from poker_player order by earnings desc limit 1"
  },
  {
    "db_id": "orchestra",
    "input": "How many orchestras are there? | select count ( distinct orchestra ) from orchestra | How many of them are there have no performance?",
    "label": "CLARIFY",
    "output": "Did you mean to ask for the number of orchestras that have no performance?"
  },
  {
    "db_id": "orchestra",
    "input": "Yes  | select count ( orchestra ) from orchestra where orchestra_id not in ( select orchestra_id from performance ) | Can you show me its id and its name please?",
    "label": "CONFIRM_SQL",
    "output": "select orchestra_id , orchestra from orchestra where orchestra_id not in ( select orchestra_id from performance )"
  },
  {
    "db_id": "concert_singer",
    "input": "Find the name and location of the stadiums which some concerts happened in the years of both 2014 and 2015. | select stadium.name , stadium.location from concert join stadium on concert.stadium_id = stadium.stadium_id where concert.year = 2014 intersect select stadium.name , stadium.location from concert join stadium on concert.stadium_id = stadium.stadium_id where concert.year = 2015 | Which year did the concert Super bootcamp happen in?",
    "label": "CONFIRM_SQL",
    "output": "select year from concert where concert_name like '%Super bootcamp%'"
  },
  {
    "db_id": "concert_singer",
    "input": "And the concert named Auditions? | select year from concert where concert_name like '%Auditions%' | What stadium did it happen in?",
    "label": "CONFIRM_SQL",
    "output": "select stadium.name from stadium join concert on stadium.stadium_id = concert.stadium_id where concert.concert_name like '%Auditions%'"
  },
  {
    "db_id": "concert_singer",
    "input": "What are the names and locations of stadiums which had some concerts in either 2014 or 2015? | select stadium.name , stadium.location from concert join stadium on concert.stadium_id = stadium.stadium_id where concert.year = 2014 or concert.year = 2015 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye"
  },
  {
    "db_id": "flight_2",
    "input": "how many flights does United Airlines operate in USA? | What do you mean by operate in USA? | how many flights does United Airlines have?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from airlines join flights on flights.airline = airlines.uid where airlines.airline = 'United Airlines'"
  },
  {
    "db_id": "flight_2",
    "input": "and how many destination airports do these flights have? | select count ( distinct flights.destairport ) from airlines join flights on flights.airline = airlines.uid where airlines.airline = 'United Airlines' | how many of those flights go to airport \"ASY\"? ",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from airlines join flights on flights.airline = airlines.uid where airlines.airline = 'United Airlines' and flights.destairport = 'ASY'"
  },
  {
    "db_id": "flight_2",
    "input": "so there are no United Airlines flights with destination \"ASY\"? | select count ( * ) from airlines join flights on flights.airline = airlines.uid where airlines.airline = 'United Airlines' and flights.destairport = 'ASY' | Thanks!",
    "label": "WELCOME",
    "output": "Sure! My pleasure"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "what are the degree_program_id in the Table Name: Student_Enrolment? | select degree_program_id from student_enrolment | what are the semester_id in the Table Name: Student_Enrolment?",
    "label": "CONFIRM_SQL",
    "output": "select semester_id from student_enrolment"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "what are the semester_name in the Table Name: Semesters? | select semester_name from semesters | what is the semester which most student registered in? show both the name and the id.",
    "label": "CONFIRM_SQL",
    "output": "select semesters.semester_name , semesters.semester_id from semesters join student_enrolment on semesters.semester_id = student_enrolment.semester_id group by semesters.semester_id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "tvshow",
    "input": "Which TV channels do not play any cartoons by Ben Jones?  List the ids. | select id from tv_channel except select channel from cartoon where directed_by = 'Ben Jones' | And which channels play Ben Jones's cartoons?",
    "label": "CONFIRM_SQL",
    "output": "select id from tv_channel where id in ( select channel from cartoon where directed_by = 'Ben Jones' )"
  },
  {
    "db_id": "tvshow",
    "input": "What cartoon titles do channels play?  | select title from cartoon where directed_by = 'Ben Jones' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye!"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Can you show me document ids? | select document_id from paragraphs | Can you show the number of paragraphs in each document?",
    "label": "CONFIRM_SQL",
    "output": "select document_id , count ( * ) from paragraphs group by document_id"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Can you order it by document id? | select document_id , count ( * ) from paragraphs group by document_id order by document_id asc | Thanks!",
    "label": "GOOD_BYE",
    "output": "bye!"
  },
  {
    "db_id": "dog_kennels",
    "input": "Can you show me a list of owner ids and zip codes? | can  you  give more infor  about  this question? | I want you to extract just the owner ids and zip codes from the table. Does it make sense?",
    "label": "CONFIRM_SQL",
    "output": "select owner_id , zip_code from owners"
  },
  {
    "db_id": "dog_kennels",
    "input": "Hmm, can you put the owner ids, dog ids and the cost of treatment in a table? | select owners.owner_id , dogs.dog_id , treatments.cost_of_treatment from owners join dogs on owners.owner_id = dogs.owner_id join treatments on dogs.dog_id = treatments.dog_id | Which owner name and id has paid the largest amount of money in total for their dogs?",
    "label": "CLARIFY",
    "output": "Did  you mean  the  full name?"
  },
  {
    "db_id": "dog_kennels",
    "input": "Just the first name will be fine. | select owners.first_name , owners.owner_id from owners join dogs on owners.owner_id = dogs.owner_id join treatments on dogs.dog_id = treatments.dog_id group by owners.owner_id order by sum ( treatments.cost_of_treatment ) desc limit 1 | To make sure, can you also show me the last name of Jaclyn?",
    "label": "CONFIRM_SQL",
    "output": "select last_name from owners where first_name = 'Jaclyn'"
  },
  {
    "db_id": "dog_kennels",
    "input": "As a last thing, can you also tell me the owner id and zip code of Jaclyn Stoltenberg, who has paid the largest amount of money in total for their dogs? | select owners.owner_id , owners.zip_code from owners join dogs on owners.owner_id = dogs.owner_id join treatments on dogs.dog_id = treatments.dog_id group by owners.owner_id order by sum ( treatments.cost_of_treatment ) desc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "welcome  and  bye\n"
  },
  {
    "db_id": "flight_2",
    "input": "Howdy!  Can you show me a list of all flight numbers? | select flightno from flights | Excellent!  Can you update this list to include a column with the destination airport code for each of these?",
    "label": "CONFIRM_SQL",
    "output": "select flightno , destairport from flights"
  },
  {
    "db_id": "flight_2",
    "input": "Nice!  Can you tell the quantity of flights that had Aberdeen or Abilene as their destination cities? | select count ( * ) from flights join airports on flights.destairport = airports.airportcode where airports.city = 'Aberdeen' or airports.city = 'Abilene' | Thank you!  So none of the flights have neither APG nor ABR as their \"destination airport\"?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from flights join airports on flights.destairport = airports.airportcode where airports.city = 'Aberdeen' or airports.city = 'Abilene'"
  },
  {
    "db_id": "flight_2",
    "input": "Okay!  Can you tell me the airport city that has the most flights landing in it? | select destairport from flights group by destairport order by count ( * ) desc limit 1 | Thanks!  ",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "flight_2",
    "input": "How many flights are arriving in the city called Aberdeen? | select count ( * ) from flights join airports on flights.destairport = airports.airportcode where airports.city = 'Aberdeen' | How many flights are there departing Aberdeen?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from flights join airports on flights.sourceairport = airports.airportcode where airports.city = 'Aberdeen'"
  },
  {
    "db_id": "world_1",
    "input": "WHAT ARE THE AFRICAN COUNTRIES THAT HAVE POPULATION LESS THAN ANY COUNTRY IN ASIA | select name from country where continent = 'Africa' and population < ( select max ( population ) from country where continent = 'Asia' ) | FROM WHICH CONTINENT IS ARUBA",
    "label": "CONFIRM_SQL",
    "output": "select continent from country where name = 'Aruba'"
  },
  {
    "db_id": "world_1",
    "input": "WHAT IS THE LOCAL NAME OF ANGOLA | select localname from country where name = 'Angola' | SURFACE AREA  OF AFGHANISTAN",
    "label": "CONFIRM_SQL",
    "output": "select surfacearea from country where name = 'Afghanistan'"
  },
  {
    "db_id": "world_1",
    "input": "WHAT IS THE CODE OF ARUBA | select code from country where name = 'Aruba' | THANK YOU",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "dog_kennels",
    "input": "kindly give me the names that might be used for professionals or owners but cannot be use for dog names | select first_name from professionals union select first_name from owners except select name from dogs | Are there names that are mostly used by professional but aren't used for dog names",
    "label": "CLARIFY",
    "output": "Can you please clarify what you would like me to search the database for?"
  },
  {
    "db_id": "dog_kennels",
    "input": "What email can i use to contact Taryn | Would you like the email address of professionals with name Taryn? | Yes",
    "label": "CONFIRM_SQL",
    "output": "select email_address from professionals where first_name = 'Taryn'"
  },
  {
    "db_id": "dog_kennels",
    "input": "In what state can i find Jayson | select state from professionals where first_name = 'Jayson' | thanks",
    "label": "GOOD_BYE",
    "output": "Thank you! Goodbye."
  },
  {
    "db_id": "car_1",
    "input": "What are the names of the makers who produced some cars in the year 1970? | select distinct car_makers.maker from car_makers join model_list on car_makers.id = model_list.maker join car_names on model_list.model = car_names.model join cars_data on car_names.makeid = cars_data.id where cars_data.year = '1970' | What are the models and makes of the cars produced that year?",
    "label": "CONFIRM_SQL",
    "output": "select car_names.model , car_names.make from car_makers join model_list on car_makers.id = model_list.maker join car_names on model_list.model = car_names.model join cars_data on car_names.makeid = cars_data.id where cars_data.year = '1970'"
  },
  {
    "db_id": "car_1",
    "input": "What is the full name of the maker that produced the heaviest car in the year 1970? | select car_makers.fullname from car_makers join model_list on car_makers.id = model_list.maker join car_names on model_list.model = car_names.model join cars_data on car_names.makeid = cars_data.id where cars_data.year = '1970' order by cars_data.weight desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "bye"
  },
  {
    "db_id": "tvshow",
    "input": "Did you mean the titles of cartoons? | Yes | List the cartoons that are directed by Ben Jones.",
    "label": "CONFIRM_SQL",
    "output": "select title from cartoon where directed_by = 'Ben Jones'"
  },
  {
    "db_id": "tvshow",
    "input": "List all tv channels with their id's..... | select channel , id from cartoon | Is there any other tv channel other than italian language ?",
    "label": "CONFIRM_SQL",
    "output": "select series_name from tv_channel except select series_name from tv_channel where language = 'Italian'"
  },
  {
    "db_id": "tvshow",
    "input": "Find the id of tv channels that do not play any cartoon directed by Ben Jones. | select id from tv_channel except select channel from cartoon where directed_by = 'Ben Jones' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "What is the average number of products of all stores? | select avg ( number_products ) from shop | what are the names of stores whose number of products is bigger than 6685?",
    "label": "CONFIRM_SQL",
    "output": "select name from shop where number_products > 6685"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "how many stores in total?\n | select count ( * ) from shop | Thanks!",
    "label": "WELCOME",
    "output": "welcome goodbye"
  },
  {
    "db_id": "flight_2",
    "input": "How many flights in this table? | select count ( * ) from flights | Which city has least number of departing flights?",
    "label": "CONFIRM_SQL",
    "output": "select airports.city from airports join flights on airports.airportcode = flights.sourceairport group by airports.city order by count ( * ) asc limit 1"
  },
  {
    "db_id": "flight_2",
    "input": "Find the flight number of APG? | select flightno from flights where sourceairport = 'APG' | Thanks!",
    "label": "REQUEST_MORE",
    "output": "You are welcome. Anything you'd like to know more?"
  },
  {
    "db_id": "flight_2",
    "input": "Find the airport names of DYS? | select airportname from airports where airportcode = 'DYS' | Fin the city of ABR?",
    "label": "CONFIRM_SQL",
    "output": "select city from airports where airportcode = 'ABR'"
  },
  {
    "db_id": "world_1",
    "input": "What are the countries where either English or Dutch is the official language?\n | select * from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'English' and isofficial = 'T' union select * from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'Dutch' and isofficial = 'T' | What is the official language in Belgium?",
    "label": "CONFIRM_SQL",
    "output": "select countrylanguage.language from country join countrylanguage on country.code = countrylanguage.countrycode where country.name = 'Belgium' and countrylanguage.isofficial = 'T'"
  },
  {
    "db_id": "world_1",
    "input": "What are the countries where arabic language is spoken | select country.name from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'Arabic' | Please tell me all the languages spoken in Egypt.",
    "label": "CONFIRM_SQL",
    "output": "select countrylanguage.language from country join countrylanguage on country.code = countrylanguage.countrycode where country.name = 'Egypt'"
  },
  {
    "db_id": "world_1",
    "input": "Can you tell me the number of countries where Arabic is the official language. | select count ( country.name ) from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'Arabic' and countrylanguage.isofficial = 'T' | Can you please give me the names of these countries?",
    "label": "CONFIRM_SQL",
    "output": "select country.name from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'Arabic' and countrylanguage.isofficial = 'T'"
  },
  {
    "db_id": "world_1",
    "input": "What are the populations of every country in Africa? | select name , population from country where continent = 'Africa' | What are the names and populations of every country in Asia?",
    "label": "CONFIRM_SQL",
    "output": "select name , population from country where continent = 'Asia'"
  },
  {
    "db_id": "world_1",
    "input": "What are the names of the Asian countries that have a larger population than that of any country in Africa? | select name from country where continent = 'Asia' and population > ( select min ( population ) from country where continent = 'Africa' ) | What are the populations of those countries?",
    "label": "CONFIRM_SQL",
    "output": "select name , population from country where continent = 'Asia' and population > ( select min ( population ) from country where continent = 'Africa' )"
  },
  {
    "db_id": "world_1",
    "input": "What are the government forms of those countries? | select name , governmentform from country where continent = 'Asia' and population > ( select min ( population ) from country where continent = 'Africa' ) | Thanks!",
    "label": "GOOD_BYE",
    "output": "thanks. bye."
  },
  {
    "db_id": "world_1",
    "input": "What is the name of the country with the shortest life expectancy in Asia? | select name from country where continent = 'Asia' order by lifeexpectancy asc limit 1 | And in Africa?",
    "label": "CLARIFY",
    "output": "Do you mean among country in Africa, or among the country in Africa and in Asia."
  },
  {
    "db_id": "world_1",
    "input": "SELECT Name FROM country WHERE Continent  =  \"Africa\" ORDER BY LifeExpectancy LIMIT 1 | Among country in Africa | select name from country where continent = 'Africa' order by lifeexpectancy asc limit 1",
    "label": "INFORM_SQL",
    "output": "What is the GNP of Afghanistan?"
  },
  {
    "db_id": "world_1",
    "input": "select gnp from country where name = 'Afghanistan' | What is the population of Afghanistan? | select population from country where name = 'Afghanistan'",
    "label": "THANK_YOU",
    "output": "Thanks!"
  },
  {
    "db_id": "poker_player",
    "input": "How much did the winning poker player make? | select earnings from poker_player | Cool who was the winner?",
    "label": "SORRY",
    "output": "Sorry the information is not available from the table."
  },
  {
    "db_id": "poker_player",
    "input": "Can you rank the poker players earnings from highest to lowest? | select earnings from poker_player order by earnings desc | How many final tables did the poker player with the least amount of earnings make?",
    "label": "CONFIRM_SQL",
    "output": "select final_table_made from poker_player order by earnings asc limit 1"
  },
  {
    "db_id": "poker_player",
    "input": "What about the poker player with the most earnings how many final table did they make? | select final_table_made from poker_player order by earnings desc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Hello there!  Can you please list all the template IDs and which document IDs they are associated with? | select template_id from documents | Thanks!  Unfortunately, I am seeing only the Template_IDs.  Can you update the list to show the document IDs as well?",
    "label": "CONFIRM_SQL",
    "output": "select template_id , document_id from documents"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Excellent!  Are there any template ids not associated with any document id? | select template_id from templates except select template_id from documents | Alright!  Can you show me a list of the Template_IDs for each template that is not associated with a Document_ID?",
    "label": "CONFIRM_SQL",
    "output": "select template_id from templates except select template_id from documents"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Nice!  Finally, can you update that list to show the associated template type code for each of these? | select templates.template_id , templates.template_type_code from templates join documents on templates.template_id = documents.template_id | Thanks!",
    "label": "WELCOME",
    "output": "welcome,goodbye"
  },
  {
    "db_id": "dog_kennels",
    "input": "Tell me how many dogs have gone through any treatments. | select count ( * ) from dogs where dog_id in ( select dog_id from treatments ) | Tell me how old the youngest is.",
    "label": "CLARIFY",
    "output": "Do you mean the youngest among those that have gone through any treatment?"
  },
  {
    "db_id": "dog_kennels",
    "input": "yes | select min ( age ) from dogs where dog_id in ( select dog_id from treatments ) | And how old is the oldest that has gone through any treatment?",
    "label": "CONFIRM_SQL",
    "output": "select max ( age ) from dogs where dog_id in ( select dog_id from treatments )"
  },
  {
    "db_id": "dog_kennels",
    "input": "How about the average age? | Do you mean the average age of those that have gone through any treatment? | yes",
    "label": "CONFIRM_SQL",
    "output": "select avg ( age ) from dogs where dog_id in ( select dog_id from treatments )"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Hi there! How many different semesters does this list have? | Do  you  mean  the type of  semester name？ | Yes!  My apologies for being unclear.  How many different semester name types are on this list?",
    "label": "CONFIRM_SQL",
    "output": "select distinct semester_name from semesters"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Awesome!  Much appreciated!  Can you filter this list to show just the semester names which do not have any \nstudent enrolment ids associated, or in other words semesters which do not have any students enrolled? | select semester_name from semesters where semester_id not in ( select semester_id from student_enrolment ) | Thank you!  Can you update this list to show the associated semester IDs and semester descriptions?",
    "label": "CONFIRM_SQL",
    "output": "select semester_id , semester_name , semester_description from semesters where semester_id not in ( select semester_id from student_enrolment )"
  },
  {
    "db_id": "pets_1",
    "input": "How many female students are on the list? | select count ( * ) from student where sex = 'F' | What is the full names of least aged students on the list?",
    "label": "CONFIRM_SQL",
    "output": "select lname , fname from student order  by age limit 1"
  },
  {
    "db_id": "pets_1",
    "input": "Find the average age of students who do not have any pet? | select avg ( age ) from student where stuid not in ( select student.stuid from student join has_pet on student.stuid = has_pet.stuid ) | What is the city code of student id 1003?",
    "label": "CONFIRM_SQL",
    "output": "select city_code from student where stuid = 1003"
  },
  {
    "db_id": "tvshow",
    "input": "Which country tv channels some cartoon written by todd casey? | select tv_channel.country from tv_channel join cartoon on tv_channel.id = cartoon.channel where cartoon.written_by = 'Todd Casey' | What is the title of cartoon written by todd casey?",
    "label": "CONFIRM_SQL",
    "output": "select title from cartoon where written_by = 'Todd Casey'"
  },
  {
    "db_id": "tvshow",
    "input": "Who directed the cartoon titled enter the outsiders? | select directed_by from cartoon where title = 'Enter the Outsiders!' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "world_1",
    "input": "HOW MANY LANGUAGE ARE THERE?\n  | select count ( distinct language ) from countrylanguage | WHAT IS THE POPULATION OF Aruba",
    "label": "CONFIRM_SQL",
    "output": "select population from country where name = 'Aruba'"
  },
  {
    "db_id": "world_1",
    "input": "WHAT IS Afghanistan GNPOld? | select gnpold from country where name = 'Afghanistan' | K THANKS",
    "label": "REQUEST_MORE",
    "output": "Do you have any other questions? Thanks"
  },
  {
    "db_id": "wta_1",
    "input": "What are the codes of countries that have more than 50 players? | select country_code from players group by country_code having count ( * ) > 50 | What are the codes of countries that have less than 40 players?",
    "label": "CONFIRM_SQL",
    "output": "select country_code from players group by country_code having count ( * ) < 40"
  },
  {
    "db_id": "wta_1",
    "input": "What are the player names from the country code AHO? | Do you want first name and last name? | yes",
    "label": "CONFIRM_SQL",
    "output": "select first_name , last_name from players where country_code = 'AHO'"
  },
  {
    "db_id": "wta_1",
    "input": "What are their player IDs? | select player_id from players where country_code = 'AHO' | What hand is player id 206449?",
    "label": "CONFIRM_SQL",
    "output": "select hand from players where player_id = 206449"
  },
  {
    "db_id": "wta_1",
    "input": "How many other players have that? | select count ( * ) from players where hand = 'U' | Thanks!",
    "label": "REQUEST_MORE",
    "output": "Sure! Do you want more?"
  },
  {
    "db_id": "battle_death",
    "input": "Can you please show the names of the battles that had no ships lost in the 'English Channel'? | select name from battle except select battle.name from battle join ship on battle.id = ship.lost_in_battle where ship.location = 'English Channel' | What are the results of those battles?",
    "label": "CONFIRM_SQL",
    "output": "select result from battle where name not in ( select battle.name from battle join ship on battle.id = ship.lost_in_battle where ship.location = 'English Channel' )"
  },
  {
    "db_id": "battle_death",
    "input": "Who are the Bulgarian commanders of those battles, please? | select bulgarian_commander from battle where name not in ( select battle.name from battle join ship on battle.id = ship.lost_in_battle where ship.location = 'English Channel' ) | What were the dates of those battles?",
    "label": "CONFIRM_SQL",
    "output": "select date from battle where name not in ( select battle.name from battle join ship on battle.id = ship.lost_in_battle where ship.location = 'English Channel' )"
  },
  {
    "db_id": "battle_death",
    "input": "What ship type was in those battles? | Sorry, I cannot answer this. | Who were the latin commanders of those battles?",
    "label": "CONFIRM_SQL",
    "output": "select latin_commander from battle where name not in ( select battle.name from battle join ship on battle.id = ship.lost_in_battle where ship.location = 'English Channel' )"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "How many stores are there? | Did you mean to ask for the number of shops? | Yes",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from shop"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "What is the most products that one shop has? | select max ( number_products ) from shop | What about the minimum number or products that one shop has?",
    "label": "CONFIRM_SQL",
    "output": "select min ( number_products ) from shop"
  },
  {
    "db_id": "dog_kennels",
    "input": "which breed is the top ranked? | select breeds.breed_name from breeds join dogs on breeds.breed_code = dogs.breed_code group by breeds.breed_name order by count ( * ) desc limit 1 | what is the total count for bulldog?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from breeds join dogs on breeds.breed_code = dogs.breed_code where breeds.breed_name = 'Bulldog'"
  },
  {
    "db_id": "dog_kennels",
    "input": "after bulldog, which breed has the next most dogs? | select breeds.breed_name from breeds join dogs on breeds.breed_code = dogs.breed_code group by breeds.breed_name order by count ( * ) desc limit 2 | are there any breeds with 0 dogs?",
    "label": "CONFIRM_SQL",
    "output": "select breeds.breed_name except select breeds.breed_name from breeds join dogs on breeds.breed_code = dogs.breed_code group by breeds.breed_name"
  },
  {
    "db_id": "dog_kennels",
    "input": "any with 1 dog? | select breeds.breed_name from breeds join dogs on breeds.breed_code = dogs.breed_code group by breeds.breed_name having count ( * ) == 1 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "pets_1",
    "input": "Do you mean the first name of all students who have cat pets? | Yes | What are the names of all students who have cat pets?",
    "label": "CONFIRM_SQL",
    "output": "select student.fname from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat'"
  },
  {
    "db_id": "pets_1",
    "input": "What are the first names of all students who have dog pets? | select student.fname from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'dog' | How many students have any type of pet?",
    "label": "CONFIRM_SQL",
    "output": "select count ( has_pet.stuid ) from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid"
  },
  {
    "db_id": "pets_1",
    "input": "Are there any students that have both a cat and a dog? | select student.fname from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat' intersect select student.fname from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'dog' | What is the age of Linda's pet?",
    "label": "CONFIRM_SQL",
    "output": "select pets.pet_age from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where student.fname = 'Linda'"
  },
  {
    "db_id": "museum_visit",
    "input": "What are the names who have a membership level higher than 4? | select name from visitor where level_of_membership > 4 | And can you add a column showing their age?",
    "label": "CONFIRM_SQL",
    "output": "select name , age from visitor where level_of_membership > 4"
  },
  {
    "db_id": "museum_visit",
    "input": "And now sort the list by age with oldest first. | select name , age from visitor where level_of_membership > 4 order by age desc | Thanks!",
    "label": "REQUEST_MORE",
    "output": "Thank you, would you like to know anything else? "
  },
  {
    "db_id": "museum_visit",
    "input": "OK...what are their customer IDs? | select id from visitor where level_of_membership > 4 order by age desc | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, good bye. "
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "who are the students enrolled in 2 degree programs in one semester? | did you want to return their first, middle and last names? | yes",
    "label": "CONFIRM_SQL",
    "output": "select students.first_name , students.middle_name , students.last_name , students.student_id from students join student_enrolment on students.student_id = student_enrolment.student_id group by students.student_id having count ( * ) = 2"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "what are their student_id? | select students.student_id from students join student_enrolment on students.student_id = student_enrolment.student_id group by students.student_id having count ( * ) = 2 | what is student_id 4 email address",
    "label": "CONFIRM_SQL",
    "output": "select email_address from students where student_id = 4"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "what is Timothy Anna Ward's date first registered? | select date_first_registered from students where first_name = 'Timmothy' and middle_name = 'Anna' and last_name = 'Ward' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye."
  },
  {
    "db_id": "dog_kennels",
    "input": "How many dog owners live in Virginia? | select count ( * ) from owners join dogs on owners.owner_id = dogs.owner_id where owners.state = 'Virginia' | What is their name?\n",
    "label": "CONFIRM_SQL",
    "output": "select owners.first_name , owners.last_name from owners join dogs on owners.owner_id = dogs.owner_id where owners.state = 'Virginia'"
  },
  {
    "db_id": "dog_kennels",
    "input": "And the name of their dog?\n | select dogs.name from owners join dogs on owners.owner_id = dogs.owner_id where owners.state = 'Virginia' | What breed of dog is bessie?",
    "label": "CONFIRM_SQL",
    "output": "select dogs.breed_code from owners join dogs on owners.owner_id = dogs.owner_id where dogs.name = 'Bessie'"
  },
  {
    "db_id": "dog_kennels",
    "input": "And what size dog is she? | select dogs.size_code from owners join dogs on owners.owner_id = dogs.owner_id where dogs.name = 'Bessie' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "orchestra",
    "input": "How many record companies are there? | select count ( record_company ) from orchestra | How many orchestras are there?",
    "label": "CONFIRM_SQL",
    "output": "select count ( orchestra_id ) from orchestra"
  },
  {
    "db_id": "orchestra",
    "input": "Do any conductors work for more than one orchestra? | select count ( orchestra ) from orchestra group by conductor_id having count ( orchestra ) > 1 | Can you list the orchestras by the date they were founded for me starting with the oldest?",
    "label": "CLARIFY",
    "output": "Do you mean listing the names of the orchestras by the date they were founded starting with the oldest?"
  },
  {
    "db_id": "orchestra",
    "input": "yes. | select orchestra from orchestra order by year_of_founded asc | What year was the Royal Danish Orchestra founded?",
    "label": "CONFIRM_SQL",
    "output": "select year_of_founded from orchestra where orchestra = 'Royal Danish Orchestra'"
  },
  {
    "db_id": "orchestra",
    "input": "What record company is shared by the most orchestras? | select record_company from orchestra group by record_company order by count ( * ) desc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome. Goodbye."
  },
  {
    "db_id": "flight_2",
    "input": "How many 'United Airlines' flights go to the Airport 'ASY'? | select count ( * ) from airlines join flights on flights.airline = airlines.uid where airlines.airline = 'United Airlines' and flights.destairport = 'ASY' | What is the airline ID of United Airlines?",
    "label": "CONFIRM_SQL",
    "output": "select uid from airlines where airline = 'United Airlines'"
  },
  {
    "db_id": "flight_2",
    "input": "How many airlines with airline id 1 go to the destination airport ASY? | select count ( * ) from flights where airline = 1 and destairport = ' ASY' | Thanks!",
    "label": "GOOD_BYE",
    "output": "thank. bye."
  },
  {
    "db_id": "car_1",
    "input": "How many Volvo cars are there? | select count ( * ) from car_names where model = 'volvo' | Which Volvo car has the least accelerate?",
    "label": "CLARIFY",
    "output": "Do you want its car id?"
  },
  {
    "db_id": "car_1",
    "input": "Yes | select cars_data.id from cars_data join car_names on cars_data.id = car_names.makeid where car_names.model = 'volvo' order by cars_data.accelerate asc limit 1 | How many cylinders does that car have?",
    "label": "CONFIRM_SQL",
    "output": "select cars_data.cylinders from cars_data join car_names on cars_data.id = car_names.makeid where car_names.model = 'volvo' order by cars_data.accelerate asc limit 1"
  },
  {
    "db_id": "network_1",
    "input": "Do you mean the number of friends? | Yes | How many students are there?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from highschooler"
  },
  {
    "db_id": "network_1",
    "input": "What about friends? | select count ( * ) from friend | What are the names of all the highschoolers who have friends ?",
    "label": "CONFIRM_SQL",
    "output": "select highschooler.name from friend join highschooler on friend.student_id = highschooler.id"
  },
  {
    "db_id": "network_1",
    "input": "Can you show me their corresponding friends\n as well? | select highschooler.name , count ( * ) from friend join highschooler on friend.student_id = highschooler.id group by friend.student_id | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Which semester did bachelor students enroll? List the id. | select distinct student_enrolment.semester_id from degree_programs join student_enrolment on degree_programs.degree_program_id = student_enrolment.degree_program_id where degree_summary_name = 'Master' | What is the degree summary description of student with id 14?",
    "label": "CONFIRM_SQL",
    "output": "select degree_programs.degree_summary_description from degree_programs join student_enrolment on degree_programs.degree_program_id = student_enrolment.degree_program_id where student_enrolment.student_id = 14"
  },
  {
    "db_id": "car_1",
    "input": "Which model saves the most gasoline? That is to say, have the maximum miles per gallon? | select car_names.model from car_names join cars_data on car_names.makeid = cars_data.id order by cars_data.mpg desc limit 1 | Which model has the highest horsepower?",
    "label": "CONFIRM_SQL",
    "output": "select car_names.model from car_names join cars_data on car_names.makeid = cars_data.id order by cars_data.horsepower desc limit 1"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "what is the age of George Chuter? | select age from employee where name = 'George Chuter' | what is the age of lee mears?",
    "label": "CONFIRM_SQL",
    "output": "select age from employee where name = 'Lee Mears'"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "find the name of the employee who got the highest one time bonus? | select employee.name from employee join evaluation on employee.employee_id = evaluation.employee_id order by evaluation.bonus desc limit 1 | thanks!",
    "label": "WELCOME",
    "output": "welcome,goodbye"
  },
  {
    "db_id": "poker_player",
    "input": "What are the names of non poker players? | select name from people where people_id not in ( select people_id from poker_player ) | What are the names of people who play poker?",
    "label": "CONFIRM_SQL",
    "output": "select name from people where people_id in ( select people_id from poker_player )"
  },
  {
    "db_id": "wta_1",
    "input": "how many players are presented on the table | select count ( * ) from players | list out the players first name",
    "label": "CONFIRM_SQL",
    "output": "select first_name from players"
  },
  {
    "db_id": "wta_1",
    "input": "what is the country code of Mirjana | select country_code from players where first_name = 'Mirjana' | what is the birth date of Justine",
    "label": "CONFIRM_SQL",
    "output": "select birth_date from players where first_name = 'Mirjana'"
  },
  {
    "db_id": "car_1",
    "input": "what models are produced by the make General Motors?\n | select distinct model_list.model from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where car_makers.fullname = 'General Motors' | what models have a weight greater than 3500",
    "label": "CONFIRM_SQL",
    "output": "select distinct model_list.model from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where cars_data.weight > 3500"
  },
  {
    "db_id": "car_1",
    "input": "could you list the models from the previous two questions with no duplicates please | select distinct model_list.model from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where car_makers.fullname = 'General Motors' or cars_data.weight <= 3500 | can you list the models that weight greater than 3500 or have the maker General Motors, but not both",
    "label": "CONFIRM_SQL",
    "output": "select distinct model_list.model from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where car_makers.fullname = 'General Motors' or cars_data.weight <= 3500 except select distinct model_list.model from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where car_makers.fullname = 'General Motors' and cars_data.weight <= 3500"
  },
  {
    "db_id": "poker_player",
    "input": "Which height of Aleksey Ostapenko? | select height from people where name = 'Aleksey Ostapenko' | Who the person is born on August 16, 1982?",
    "label": "CONFIRM_SQL",
    "output": "select name from people where birth_date = 'August 16, 1982'"
  },
  {
    "db_id": "poker_player",
    "input": "What are the people id of nationality Russia? | select people_id from people where nationality = 'Russia' | What are the nationalities that are shared by at least two people?",
    "label": "CONFIRM_SQL",
    "output": "select nationality from people group by nationality having count ( * ) >= 2"
  },
  {
    "db_id": "world_1",
    "input": "What is the population of Afghanistan? | select population from country where name = 'Afghanistan' | And for Aruba?",
    "label": "CONFIRM_SQL",
    "output": "select population from country where name = 'Aruba'"
  },
  {
    "db_id": "world_1",
    "input": "What languages are spoken in Aruba? | select countrylanguage.language from country join countrylanguage on country.code = countrylanguage.countrycode where country.name = 'Aruba' | Is there an official language for the country?",
    "label": "CLARIFY",
    "output": "For which country? Aruba?"
  },
  {
    "db_id": "world_1",
    "input": "Yes. | select countrylanguage.language from country join countrylanguage on country.code = countrylanguage.countrycode where country.name = 'Aruba' and countrylanguage.isofficial = 'T' | What about for Afghanistan?",
    "label": "CONFIRM_SQL",
    "output": "select countrylanguage.language from country join countrylanguage on country.code = countrylanguage.countrycode where country.name = 'Afghanistan' and countrylanguage.isofficial = 'T'"
  },
  {
    "db_id": "world_1",
    "input": "How many other countries speak Dari? | select count ( * ) from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'Dari' and country.name != 'Afghanistan' | Do other countries speak Pashto?",
    "label": "CONFIRM_SQL",
    "output": "select country.name from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'Pashto' and country.name != 'Afghanistan'"
  },
  {
    "db_id": "world_1",
    "input": "Is it an official language of Pakistan? | select countrylanguage.language from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.isofficial = 'T' and country.name = 'Pakistan' | Thanks!",
    "label": "REQUEST_MORE",
    "output": "Sure! You are welcome! Anything else I can do?"
  },
  {
    "db_id": "dog_kennels",
    "input": "In what descending order? | IN DESCENDING ORDER OF THE COST OF TREATMENT | LIST THE DOG NAMES WITH TREATMENT COST\n",
    "label": "CONFIRM_SQL",
    "output": "select name , cost_of_treatment from dogs join treatments"
  },
  {
    "db_id": "dog_kennels",
    "input": "ARRANGE THE COST OF TREATMENT IN DESCENDING ORDER | select cost_of_treatment from dogs join treatments order by cost_of_treatment desc | FIND THE DOG NAMES WHICH COST LESS THAN 1000 FOR TREATMENT",
    "label": "CONFIRM_SQL",
    "output": "select name from dogs where dog_id not in ( select dog_id from treatments group by dog_id having sum ( cost_of_treatment ) < 1000 )"
  },
  {
    "db_id": "museum_visit",
    "input": "What age of Gonzalo Higuaín? | select age from visitor where name = 'Gonzalo Higuaín' | How many tickets of customer id 5?",
    "label": "CONFIRM_SQL",
    "output": "select num_of_ticket from visitor join visit on visitor.id = visit.visitor_id where visitor_id = 5"
  },
  {
    "db_id": "museum_visit",
    "input": "How many spent of Arjen Robben? | select total_spent from visitor join visit on visitor.id = visit.visitor_id where name = 'Arjen Robben' | Find the name and age of the visitor who bought the most tickets at once.",
    "label": "CONFIRM_SQL",
    "output": "select visitor.name , visitor.age from visitor join visit on visitor.id = visit.visitor_id order by visit.num_of_ticket desc limit 1"
  },
  {
    "db_id": "world_1",
    "input": "What are the regions that use English, please? | select distinct country.region from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'English' | What are the regions that use Dutch, please?",
    "label": "CONFIRM_SQL",
    "output": "select distinct country.region from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'Dutch'"
  },
  {
    "db_id": "world_1",
    "input": "What are the life expectancies of those regions? | select distinct country.lifeexpectancy from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'Dutch' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye!"
  },
  {
    "db_id": "wta_1",
    "input": "What are the names of the 3 youngest winners across all matches? | select winner_name from matches order by winner_age asc limit 3 | What are their ranks?",
    "label": "CLARIFY",
    "output": "do you want to show their names as well?"
  },
  {
    "db_id": "wta_1",
    "input": "yes, please | select distinct winner_name , winner_rank from matches order by winner_age asc limit 3 | There are the names and ranks of the 3 youngest winners across all matches.",
    "label": "INFORM_SQL",
    "output": "What is the loser name for each of those matches?"
  },
  {
    "db_id": "dog_kennels",
    "input": "Did you mean first name? | Yes | List the names of all the professionals. ",
    "label": "CONFIRM_SQL",
    "output": "select first_name , last_name from professionals"
  },
  {
    "db_id": "dog_kennels",
    "input": "List the names of all professionals that live in a city containing the substring West. | select first_name , last_name from professionals where city like '%West%' | List the role of the professional named Taryn. ",
    "label": "CONFIRM_SQL",
    "output": "select role_code from professionals where first_name = 'Taryn'"
  },
  {
    "db_id": "dog_kennels",
    "input": "List the role, street, city, and state of the professional with first name Taryn.  | select role_code , street , city , state from professionals where first_name = 'Taryn' | List the name of all professionals with the same state as Taryn. ",
    "label": "REJECT",
    "output": "Sorry I can't answer this question"
  },
  {
    "db_id": "dog_kennels",
    "input": "List the names of all the professionals and their state.  | select first_name , state from professionals | List the names of all professionals with the state Indiana. ",
    "label": "CONFIRM_SQL",
    "output": "select first_name from professionals where state = 'Indiana'"
  },
  {
    "db_id": "battle_death",
    "input": "How many death events are there? | select count ( * ) from death | Which event has the most deaths?",
    "label": "CLARIFY",
    "output": "What information do you need? all the information of this event or some specific information, like the note?"
  },
  {
    "db_id": "battle_death",
    "input": "Which death event has the highest number killed? | select * from death where killed = ( select max ( killed ) from death ) | Was anyone injured in these death events?",
    "label": "CONFIRM_SQL",
    "output": "select * from death where injured > 0"
  },
  {
    "db_id": "battle_death",
    "input": "Were there any death events with the substring East? | You mean the events with the substring East in the event note? | Yes, please list them",
    "label": "CONFIRM_SQL",
    "output": "select * from death where note like '%East%'"
  },
  {
    "db_id": "battle_death",
    "input": "What are the death situations caused by the ship with tonnage 't' ? | select death.killed from death join ship on death.caused_by_ship_id = ship.id where ship.tonnage = 't' | What are the injury situations caused by the ship with tonnage 't' ?",
    "label": "CONFIRM_SQL",
    "output": "select death.injured from death join ship on death.caused_by_ship_id = ship.id where ship.tonnage = 't'"
  },
  {
    "db_id": "battle_death",
    "input": "Tell me the total number of death and injury situations caused by the ship with tonnage 't'.. | select count ( death.id ) from death join ship on death.caused_by_ship_id = ship.id where ship.tonnage = 't' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome. Good bye!"
  },
  {
    "db_id": "car_1",
    "input": "Can you list the number of car makers on each continent? | select continents.continent , count ( * ) from continents join countries on continents.contid = countries.continent join car_makers on countries.countryid = car_makers.country group by continents.continent | What about the number of car makers in the country USA?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from car_makers join countries on countries.countryid = car_makers.country where countries.countryname = 'usa'"
  },
  {
    "db_id": "car_1",
    "input": "How about in the country Germany? | select count ( * ) from car_makers join countries on countries.countryid = car_makers.country where countries.countryname = 'germany' | What about France?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from car_makers join countries on countries.countryid = car_makers.country where countries.countryname = 'france'"
  },
  {
    "db_id": "world_1",
    "input": "What is the total number of countries? | select count ( * ) from country | How many cities are there?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from city"
  },
  {
    "db_id": "world_1",
    "input": "Can you tell me the region where the city of Kabul is? | select region from country join city on country.code = city.countrycode where city.name = 'Kabul' | Yes. How many cities are the in the region?",
    "label": "CONFIRM_SQL",
    "output": "select count ( city.name ) from country join city on country.code = city.countrycode where country.region = 'Southern and Central Asia'"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "How many documents have template type code BK? | select count ( * ) from templates join documents on templates.template_id = documents.template_id where templates.template_type_code = 'BK' | And their names?",
    "label": "CONFIRM_SQL",
    "output": "select documents.document_name from templates join documents on templates.template_id = documents.template_id where templates.template_type_code = 'BK'"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "How many documents do not have template type code BK? | select count ( * ) from documents where document_name not in ( select documents.document_name from templates join documents on templates.template_id = documents.template_id where templates.template_type_code = 'BK' ) | Great! I appreciate your help. Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, good bye. "
  },
  {
    "db_id": "world_1",
    "input": "What are the codes of the countries that do not speak English? | select countrycode from countrylanguage where language != 'English' | What are the codes of the countries that do not speak English whose government forms are not Republic?",
    "label": "CONFIRM_SQL",
    "output": "select code from country where governmentform != 'Republic' except select countrycode from countrylanguage where language = 'English'"
  },
  {
    "db_id": "world_1",
    "input": "What language do each of those speak, please? | select countrycode , language from countrylanguage where countrycode in ( select code from country where governmentform != 'Republic' except select countrycode from countrylanguage where language = 'English' ) | select countrycode from countrylanguage where isOfficial = \"T\" and countrycode in (SELECT Code FROM country WHERE GovernmentForm != \"Republic\" EXCEPT SELECT CountryCode FROM countrylanguage WHERE LANGUAGE  =  \"English\")",
    "label": "INFORM_SQL",
    "output": "Which of those countries is on the continent North America?"
  },
  {
    "db_id": "dog_kennels",
    "input": "which professionals live in state of indiana? | What information do you want to know about these professionals?  | I would like to know all the information about professionals?",
    "label": "CONFIRM_SQL",
    "output": "select * from professionals where state = 'Indiana'"
  },
  {
    "db_id": "dog_kennels",
    "input": "ok, I need to know the cell number of taryn | select cell_number from professionals where first_name = 'Taryn' | ok,thanks",
    "label": "GOOD_BYE",
    "output": "thank you, good bye"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Thank you. That is all. | how many templates there | select count ( * ) from templates",
    "label": "INFORM_SQL",
    "output": "what is the date effective of template id 1"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "select date_effective_from , date_effective_to from templates where template_id = 1 | what is the template type code of template id 4 | select template_type_code from templates where template_id = 4",
    "label": "INFORM_SQL",
    "output": "what is the version number of template id 0"
  },
  {
    "db_id": "concert_singer",
    "input": "Can you tell me which countries a singer above age 40 are from please? | select country from singer where age > 40 | Can you tell me which countries a singer below age 30 are from please?",
    "label": "CONFIRM_SQL",
    "output": "select distinct ( country ) from singer where age < 30"
  },
  {
    "db_id": "concert_singer",
    "input": "Can you tell me which countries a singer above age 40 and below age 30 are from please? | select country from singer where age > 40 intersect select country from singer where age < 30 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "car_1",
    "input": "WHAT IS THE ACCELERATE OF THE CAR MAKE AMC HORNET SPORTABOUT(SW) | select cars_data.accelerate from cars_data join car_names on cars_data.id = car_names.makeid where car_names.make = 'amc hornet sportabout (sw)' | WHICH CAR MODEL GIVES MORE ACCELRATION",
    "label": "CONFIRM_SQL",
    "output": "select car_names.model from cars_data join car_names on cars_data.id = car_names.makeid order by cars_data.accelerate desc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "CAN YOU WHICH CAR MODEL IS MOST RECENT RELEASED | select car_names.model from cars_data join car_names on cars_data.id = car_names.makeid order by cars_data.year desc limit 1 | THANKS! GOODBYE",
    "label": "WELCOME",
    "output": "welcome goodbye"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Did you mean the number of templates used in any document? | Yes | what are all of the template ids?",
    "label": "CONFIRM_SQL",
    "output": "select template_id from templates"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "which of those is not used in a document  | select template_id from templates except select template_id from documents | are those still effective?\n",
    "label": "CLARIFY",
    "output": "Do you mean the effective-to date of those templates?"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "yes | select date_effective_to from templates where template_id in ( select template_id from templates except select template_id from documents ) | how many are used in documents?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from templates where template_id in ( select template_id from documents )"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "and how many templates are not used? | select count ( * ) from templates where template_id in ( select template_id from templates except select template_id from documents ) | what were those IDs again?",
    "label": "CONFIRM_SQL",
    "output": "select template_id from templates except select template_id from documents"
  },
  {
    "db_id": "concert_singer",
    "input": "show the name and theme for all concerts and the number of singers in each concert. | select concert.concert_name , concert.theme , count ( * ) from singer_in_concert join concert on singer_in_concert.concert_id = concert.concert_id group by concert.concert_id | what year was super bootcamp?",
    "label": "CONFIRM_SQL",
    "output": "select year from concert where concert_name = 'Super bootcamp'"
  },
  {
    "db_id": "concert_singer",
    "input": "what is the Stadium ID for Super bootcamp? | select stadium_id from concert where concert_name = 'Super bootcamp' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome. Good bye!"
  },
  {
    "db_id": "world_1",
    "input": "What is the population in Asian continent? | select sum ( population ) from country where continent = 'Asia' | Which language has 9.5%?",
    "label": "CONFIRM_SQL",
    "output": "select language from countrylanguage where percentage = 9.5"
  },
  {
    "db_id": "world_1",
    "input": "What is the life expectancy rate in Angola? | select lifeexpectancy from country where localname = 'Angola' | What is the GNP rate of Aruba?",
    "label": "CLARIFY",
    "output": "did you mean the GNP or GNP old?"
  },
  {
    "db_id": "world_1",
    "input": "GNP | select gnp from country where localname = 'Angola' | What is the GNP old of Afghanistan?",
    "label": "CONFIRM_SQL",
    "output": "select gnpold from country where name = 'Afghanistan'"
  },
  {
    "db_id": "concert_singer",
    "input": "What are the names of the singers whose song release year is greater than the average song release year | select song_name from singer where song_release_year > ( select avg ( song_release_year ) from singer ) | What is the average song release year?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( song_release_year ) from singer"
  },
  {
    "db_id": "concert_singer",
    "input": "List the songs in increasing release years | Do you want the names of the songs ordered by their release year? | Yes I do\n",
    "label": "CONFIRM_SQL",
    "output": "select song_name from singer order by song_release_year asc"
  },
  {
    "db_id": "concert_singer",
    "input": "List all song names by singers above the average age\n | select song_name from singer where age > ( select avg ( age ) from singer ) | Thanks!",
    "label": "GOOD_BYE",
    "output": "bye."
  },
  {
    "db_id": "orchestra",
    "input": "Yes | Hi, how can I help you? | Please answer the question.what is the orchestra of conductor?",
    "label": "CLARIFY",
    "output": "Do you want all the orchestras of all conductors?"
  },
  {
    "db_id": "orchestra",
    "input": "yes | select orchestra.orchestra from conductor join orchestra on conductor.conductor_id = orchestra.conductor_id | what is the name of all conductors?",
    "label": "CONFIRM_SQL",
    "output": "select name from conductor"
  },
  {
    "db_id": "orchestra",
    "input": "What is the age of Colin Davis? | select age from conductor where name = 'Colin Davis' | OK Thanks. ",
    "label": "GOOD_BYE",
    "output": "Thank you. Goodbye!"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "how many students there | select count ( * ) from students | what is the first name of student id 3",
    "label": "CONFIRM_SQL",
    "output": "select first_name from students where student_id = 3"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "what is email address of student id 2 | select email_address from students where student_id = 2 | how many student enrolment there",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from student_enrolment"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "What are the templates ever used by any document? | select * from templates join documents on templates.template_id = documents.template_id | What are the template type descriptions for these templates?",
    "label": "CONFIRM_SQL",
    "output": "select ref_template_types.template_type_description from ref_template_types join templates on ref_template_types.template_type_code = templates.template_type_code join documents on templates.template_id = documents.template_id"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Can I get the distinct template type descriptions for these templates? | select distinct ref_template_types.template_type_description from ref_template_types join templates on ref_template_types.template_type_code = templates.template_type_code join documents on templates.template_id = documents.template_id | Thanks",
    "label": "GOOD_BYE",
    "output": "Goodbye!"
  },
  {
    "db_id": "poker_player",
    "input": "Name players whose earnings are more than 300000. | Do you mean the names of the poker players whose earnings is more than 300000? | yes names",
    "label": "CONFIRM_SQL",
    "output": "select people.name from people join poker_player on people.people_id = poker_player.people_id where poker_player.earnings > 300000"
  },
  {
    "db_id": "poker_player",
    "input": "how many poker players?  | select count ( poker_player_id ) from poker_player | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "how many students live in North Carolina? | select count ( * ) from students join addresses on students.current_address_id = addresses.address_id where addresses.state_province_county = 'NorthCarolina' | What are their first and last names?",
    "label": "CONFIRM_SQL",
    "output": "select students.first_name , students.last_name from students join addresses on students.current_address_id = addresses.address_id where addresses.state_province_county = 'NorthCarolina'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Which of those do not have degree program id? | select students.first_name , students.last_name from students join addresses on students.current_address_id = addresses.address_id where addresses.state_province_county = 'NorthCarolina' except select students.first_name , students.last_name from students join student_enrolment on students.student_id = student_enrolment.student_id | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank. bye."
  },
  {
    "db_id": "voter_1",
    "input": "What are all the area codes? | select area_code from area_code_state | What area codes voted for the contestant 'Tabatha Gehling'?",
    "label": "CONFIRM_SQL",
    "output": "select area_code_state.area_code from contestants join votes on contestants.contestant_number = votes.contestant_number join area_code_state on votes.state = area_code_state.state where contestants.contestant_name = 'Tabatha Gehling'"
  },
  {
    "db_id": "voter_1",
    "input": "What area codes voted for the contestant 'Kelly Clauss'? | select area_code_state.area_code from contestants join votes on contestants.contestant_number = votes.contestant_number join area_code_state on votes.state = area_code_state.state where contestants.contestant_name = 'Kelly Clauss' | What area codes voted for both the contestant 'Kelly Clauss' and 'Tabatha Gehling'?",
    "label": "CONFIRM_SQL",
    "output": "select area_code_state.area_code from contestants join votes on contestants.contestant_number = votes.contestant_number join area_code_state on votes.state = area_code_state.state where contestants.contestant_name = 'Tabatha Gehling' intersect select area_code_state.area_code from contestants join votes on contestants.contestant_number = votes.contestant_number join area_code_state on votes.state = area_code_state.state where contestants.contestant_name = 'Kelly Clauss'"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "how many shop are presented on the table | select count ( * ) from shop | list out the shop names",
    "label": "CONFIRM_SQL",
    "output": "select name from shop"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "what is the location of FC Haka | select location from shop where name = 'FC Haka' | what is the number of products in HJK",
    "label": "CONFIRM_SQL",
    "output": "select number_products from shop where name = 'HJK'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Hello!  Can you list all of the deparatment names and department IDs? | select department_id , department_name from departments | Excellent!  Can you filter this list to show just the department that offers the largest number of degrees?",
    "label": "CONFIRM_SQL",
    "output": "select departments.department_name , degree_programs.department_id from degree_programs join departments on degree_programs.department_id = departments.department_id group by degree_programs.department_id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Cool!  Can you show me all of the degree summary names associated with this department? | select degree_programs.degree_summary_name from departments join degree_programs on departments.department_id = degree_programs.department_id where departments.department_name = 'statistics' | Thanks!",
    "label": "WELCOME",
    "output": "welcome goodbye"
  },
  {
    "db_id": "dog_kennels",
    "input": "What are the ids of the professionals?\n | select professional_id from professionals | What is the role of each of the professionals?",
    "label": "CONFIRM_SQL",
    "output": "select professional_id , role_code from professionals"
  },
  {
    "db_id": "dog_kennels",
    "input": "Could I please have their email address and which of them did not perform any operate any treatment on dogs. | Do you mean the email addresses of professionals that did not operate any treatment on dogs? | That would be fine if it is easier for you.  ",
    "label": "CONFIRM_SQL",
    "output": "select professional_id , role_code , email_address from professionals except select professionals.professional_id , professionals.role_code , professionals.email_address from professionals join treatments on professionals.professional_id = treatments.professional_id"
  },
  {
    "db_id": "car_1",
    "input": "Can you tell me the ID of the american motor company ? | select id from car_makers join model_list on car_makers.id = model_list.maker where car_makers.fullname = 'American Motor Company' | Can you tell me the model id of the maker amc ?",
    "label": "CONFIRM_SQL",
    "output": "select modelid from car_makers join model_list on car_makers.id = model_list.maker where car_makers.maker = 'amc'"
  },
  {
    "db_id": "car_1",
    "input": "Who is maker for the ID number 2 ? | Did you mean Id or ModelId? | I mean id\n",
    "label": "CONFIRM_SQL",
    "output": "select distinct ( car_makers.maker ) from car_makers join model_list on car_makers.id = model_list.maker where car_makers.id = 2"
  },
  {
    "db_id": "car_1",
    "input": "How many car models were produced by the maker with the full name American Motor Company ? | select count ( * ) from car_makers join model_list on car_makers.id = model_list.maker where car_makers.fullname = 'American Motor Company' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "course_teach",
    "input": "list the name of the teachers and the courses assigned for them to teach | select teacher.name , course.course from course_arrange join course on course_arrange.course_id = course.course_id join teacher on course_arrange.teacher_id = teacher.teacher_id | arrange this list with the teachers name in ascending order",
    "label": "CONFIRM_SQL",
    "output": "select teacher.name , course.course from course_arrange join course on course_arrange.course_id = course.course_id join teacher on course_arrange.teacher_id = teacher.teacher_id order by teacher.name asc"
  },
  {
    "db_id": "course_teach",
    "input": "include teachers id in tha same list | select teacher.name , course.course , course_arrange.teacher_id from course_arrange join course on course_arrange.course_id = course.course_id join teacher on course_arrange.teacher_id = teacher.teacher_id order by teacher.name asc | thanks",
    "label": "GOOD_BYE",
    "output": "Goodbye."
  },
  {
    "db_id": "world_1",
    "input": "can you show countries name? | select name from country | what is the countries government form?",
    "label": "CONFIRM_SQL",
    "output": "select governmentform from country"
  },
  {
    "db_id": "world_1",
    "input": "can you show me the countries' surface area? | select surfacearea from country | thanks!",
    "label": "GOOD_BYE",
    "output": "Bye."
  },
  {
    "db_id": "tvshow",
    "input": "IN WHAT LANGUAGE SKY MUSIC AVAILABLE? | select language from tv_channel where series_name = 'Sky Music' | WHAT IS THE PACKAGE OPTION OF ALL CHANNELS?",
    "label": "CONFIRM_SQL",
    "output": "select distinct package_option from tv_channel"
  },
  {
    "db_id": "tvshow",
    "input": "IS ANY CHANNEL AVAILABLE IN HIGH DEFINITION?\n | select * from tv_channel where hight_definition_tv = 'yes' | what is the content of all the channels?",
    "label": "CONFIRM_SQL",
    "output": "select distinct content from tv_channel"
  },
  {
    "db_id": "tvshow",
    "input": "Can you please tell me the language used on the least number of TV Channels? | select language from tv_channel group by language order by count ( * ) asc limit 1 | What language is used on the most number of TV channels?",
    "label": "CONFIRM_SQL",
    "output": "select language from tv_channel group by language order by count ( * ) desc limit 1"
  },
  {
    "db_id": "tvshow",
    "input": "What is the most common content of those TV channels? | select content from tv_channel group by content order by count ( * ) desc limit 1 | What is the least common content?",
    "label": "CONFIRM_SQL",
    "output": "select content from tv_channel group by content order by count ( * ) asc limit 1"
  },
  {
    "db_id": "tvshow",
    "input": "Can you please tell me the series name of those TV Channels? | select series_name from tv_channel | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thanks. bye."
  },
  {
    "db_id": "dog_kennels",
    "input": "Which first names are used for professionals or owners? | select first_name from professionals union select first_name from owners | Which first names are used for professionals or owners, but are not used as dog names?",
    "label": "CONFIRM_SQL",
    "output": "select first_name from professionals union select first_name from owners except select name from dogs"
  },
  {
    "db_id": "dog_kennels",
    "input": "Which first names are used for professionals or owners, and are used as dog names? | select first_name from professionals union select first_name from owners union select name from dogs | Thanks!",
    "label": "GOOD_BYE",
    "output": "bye!"
  },
  {
    "db_id": "pets_1",
    "input": "Can you tell me the last names of students who have pets? | select lname from student join has_pet on has_pet.stuid = student.stuid | Hmm, I want to know the last names of students who have cats.",
    "label": "CONFIRM_SQL",
    "output": "select student.lname from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat'"
  },
  {
    "db_id": "pets_1",
    "input": "Please find out the last name of the student who has a cat that is age 3. | select student.lname from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pet_age = 3 and pets.pettype = 'cat' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "orchestra",
    "input": "Can you show me orchestra names and the major record formats? | select orchestra , major_record_format from orchestra | I want a list of orchestra names in ascending order.",
    "label": "CONFIRM_SQL",
    "output": "select orchestra from orchestra order by orchestra asc"
  },
  {
    "db_id": "orchestra",
    "input": "Hmm, please show me the record formats of orchestras in ascending order of count. | select major_record_format from orchestra group by major_record_format order by count ( * ) asc | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, good bye. "
  },
  {
    "db_id": "museum_visit",
    "input": "how many museum id in the list? | select count ( museum_id ) from museum | find the staff count in the museum with an id 3?",
    "label": "CONFIRM_SQL",
    "output": "select num_of_staff from museum where museum.museum_id = 3"
  },
  {
    "db_id": "museum_visit",
    "input": "which year open the capital plaza museum? | select open_year from museum where name = 'Capital Plaza Museum' | Thanks",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "museum_visit",
    "input": "List the names of all visitors who visited some museums more than once, please. | select visitor.name from visitor join visit on visitor.id = visit.visitor_id group by visitor.id having count ( * ) > 1 | Can you list their IDs and ages too?",
    "label": "CONFIRM_SQL",
    "output": "select visitor.name , visitor.id , visitor.age from visitor join visit on visitor.id = visit.visitor_id group by visitor.id having count ( * ) > 1"
  },
  {
    "db_id": "museum_visit",
    "input": "What are the names and level of membership for all visitors over the age of 20? | select name , level_of_membership from visitor where age > 20 | What are the names and ages of all the customers who spent over 100?",
    "label": "CONFIRM_SQL",
    "output": "select visitor.name , visitor.age from visitor join visit on visitor.id = visit.visitor_id where visit.total_spent > 100"
  },
  {
    "db_id": "world_1",
    "input": "How many government forms are in the table? | select count ( governmentform ) from country | How many of those have an average life expectancy that is longer than 72?",
    "label": "CONFIRM_SQL",
    "output": "select governmentform from country group by governmentform having avg ( lifeexpectancy ) > 72"
  },
  {
    "db_id": "world_1",
    "input": "What is the population of each of those government forms? | select sum ( population ) , governmentform from country group by governmentform having avg ( lifeexpectancy ) > 72 | What is the region for each of these?",
    "label": "REJECT",
    "output": "Sorry, I cannot answer this."
  },
  {
    "db_id": "world_1",
    "input": "What is the life expectancy for each of these? | select avg ( lifeexpectancy ) from country group by governmentform having avg ( lifeexpectancy ) > 72 | Which government forms and their populations are those for?",
    "label": "REJECT",
    "output": "Sorry, I cannot understand this question. Can you elaborate?"
  },
  {
    "db_id": "world_1",
    "input": "Which government forms have an average life expectancy over 72, and what are their populations? | select sum ( population ) , governmentform from country group by governmentform having avg ( lifeexpectancy ) > 72 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Sure! Bye!\n"
  },
  {
    "db_id": "museum_visit",
    "input": "Whats the level of membership customer id 1 has? | select level_of_membership from visitor where id = 1 | What is the name of customer id 1?",
    "label": "CONFIRM_SQL",
    "output": "select name from visitor where id = 1"
  },
  {
    "db_id": "museum_visit",
    "input": "What is the age of customer id 1? | select age from visitor where id = 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "flight_2",
    "input": "Hi, What Airline has the largest number of flights? | select airlines.airline from airlines join flights on airlines.uid = flights.airline group by airlines.airline order by count ( * ) desc limit 1 | What is the Airline with the fewest number of flights?\n",
    "label": "CONFIRM_SQL",
    "output": "select airlines.airline from airlines join flights on airlines.uid = flights.airline group by airlines.airline order by count ( * ) asc limit 1"
  },
  {
    "db_id": "flight_2",
    "input": "What is the abbreviation of AirTran Airways? | select abbreviation from airlines where airline = 'AirTran Airways' | Ah, and what is the country of AirTran Airways?",
    "label": "CONFIRM_SQL",
    "output": "select country from airlines where airline = 'AirTran Airways'"
  },
  {
    "db_id": "battle_death",
    "input": "Hi there!  Can you show me a list of all of the battle ids and the corresponding battle names? | select battle.id , battle.name from battle as battle | Great!  Can you filter this list to show just the battle IDs and battle names of the battles that had more than 10 deaths associated with them?",
    "label": "CONFIRM_SQL",
    "output": "select battle.id , battle.name from battle join ship on battle.id = ship.lost_in_battle join death on ship.id = death.caused_by_ship_id group by battle.id having sum ( death.killed ) > 10"
  },
  {
    "db_id": "battle_death",
    "input": "Wonderful!  Can you update this list to include the date of each of these three battles? | select battle.id , battle.name , battle.date from battle join ship on battle.id = ship.lost_in_battle join death on ship.id = death.caused_by_ship_id group by battle.id having sum ( death.killed ) > 10 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "pets_1",
    "input": "Hey can you tell me the average age for cats? | select avg ( pet_age ) from pets where pettype = 'cat' | What about for dogs?\n",
    "label": "CONFIRM_SQL",
    "output": "select avg ( pet_age ) from pets where pettype = 'dog'"
  },
  {
    "db_id": "pets_1",
    "input": "Thanks! Now what's the maximum age for dogs? | select max ( pet_age ) from pets where pettype = 'dog' | And the maximum age for cats and dogs?\n",
    "label": "CONFIRM_SQL",
    "output": "select max ( pet_age ) , pettype from pets group by pettype"
  },
  {
    "db_id": "pets_1",
    "input": "So what's the maximum age for just cats?\n | select max ( pet_age ) from pets where pettype = 'cat' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you! Goodybe."
  },
  {
    "db_id": "car_1",
    "input": "What are the full name of amc? | Did you mean the full name of the car maker amc? | Yes",
    "label": "CONFIRM_SQL",
    "output": "select fullname from car_makers where maker = 'amc'"
  },
  {
    "db_id": "car_1",
    "input": "What type of car making by german country? | Sorry we don't have information about type of car. Can you clarify your question? | What kind of car is produced in Germany?",
    "label": "CLARIFY",
    "output": "Did you mean the car models produced in Germany?"
  },
  {
    "db_id": "car_1",
    "input": "Yes | select model_list.model from countries join car_makers on countries.countryid = car_makers.country join model_list on car_makers.id = model_list.maker where countries.countryname = 'germany' | What are the model id of BMW?",
    "label": "CONFIRM_SQL",
    "output": "select modelid from model_list where model = 'bmw'"
  },
  {
    "db_id": "car_1",
    "input": "What are the id and names of the countries which have more than 3 cars makers or produce the 'flat' model? | select countries.countryid , countries.countryname from countries join car_makers on countries.countryid = car_makers.country group by countries.countryid having count ( * ) > 3 union select countries.countryid , countries.countryname from countries join car_makers on countries.countryid = car_makers.country join model_list on car_makers.id = model_list.maker where model_list.model = 'fiat' | Thanks!",
    "label": "GOOD_BYE",
    "output": "bye"
  },
  {
    "db_id": "dog_kennels",
    "input": "What is the phone number of the professional who has done the most treatment. | select professionals.cell_number from professionals join treatments on professionals.professional_id = treatments.professional_id group by professionals.professional_id order by count ( * ) desc limit 1 | What are the professional id of the professionals who have done at least two types of treatments?",
    "label": "CONFIRM_SQL",
    "output": "select professionals.professional_id from professionals join treatments on professionals.professional_id = treatments.professional_id group by professionals.professional_id having count ( * ) >= 2"
  },
  {
    "db_id": "dog_kennels",
    "input": "How many professionals have done only one treatment? | select count ( * ) from ( select * from professionals join treatments on professionals.professional_id = treatments.professional_id group by professionals.professional_id having count ( * ) = 1 ) | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "WHAT IS THE DOCUMENT ID WITH 1 TO 2 PARAGRAPH? | select document_id from paragraphs group by document_id having count ( * ) between 1 and 2 | WHAT IS THE DOCUMENT TEXT ",
    "label": "CLARIFY",
    "output": "Did you mean the \tParagraph Text?"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "YES \n | select paragraph_text from paragraphs group by document_id having count ( * ) between 1 and 2 | OK THANKS! GOODBYE",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "course_teach",
    "input": "Who is the youngest teacher? | select name from teacher order by age asc limit 1 | What is his hometown?",
    "label": "CONFIRM_SQL",
    "output": "select hometown from teacher order by age asc limit 1"
  },
  {
    "db_id": "course_teach",
    "input": "Are there any other teachers from there? | select name from teacher where hometown = 'Farnworth Municipal Borough' and name not is 'Vicente Carretero' | What is the age of Vicente Carretero?",
    "label": "CONFIRM_SQL",
    "output": "select age from teacher where name = 'Vicente Carretero'"
  },
  {
    "db_id": "course_teach",
    "input": "Are there any other teachers with that age? | select name from teacher where age = '26' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "pets_1",
    "input": "Are there any dog pet raised by any female student | select count ( * ) from student join has_pet on student.stuid = has_pet.stuid join pets on has_pet.petid = pets.petid where student.sex = 'F' and pets.pettype = 'dog' | Give me the names of all female students on ground",
    "label": "CLARIFY",
    "output": "What do you mean by \"on ground\"?"
  },
  {
    "db_id": "pets_1",
    "input": "That are available | select fname , lname from student where sex = 'F' | What are the city codes for all available students",
    "label": "CONFIRM_SQL",
    "output": "select distinct city_code from student"
  },
  {
    "db_id": "pets_1",
    "input": "Can i have the weight of the pets that were raised by female student | select pets.weight from student join has_pet on student.stuid = has_pet.stuid join pets on has_pet.petid = pets.petid where student.sex = 'F' | Thanks",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "car_1",
    "input": "What are the cars with the lowest horsepower? | Do you mean the id of the car with the lowest horsepower? | Yes please.",
    "label": "CONFIRM_SQL",
    "output": "select id from cars_data order by horsepower asc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "What is the average horsepower of all the cars? | select avg ( horsepower ) from cars_data | Can you list the car ids of all the cars with lower than the average horsepower?",
    "label": "CONFIRM_SQL",
    "output": "select cars_data.id from cars_data join car_names on cars_data.id = car_names.makeid where cars_data.horsepower < ( select avg ( horsepower ) from cars_data )"
  },
  {
    "db_id": "car_1",
    "input": "Could you add the model and make of each of those into the table please? | select cars_data.id , car_names.model from cars_data join car_names on cars_data.id = car_names.makeid where cars_data.horsepower < ( select avg ( horsepower ) from cars_data ) | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Hi what is the latest transcript? | select transcript_id from transcripts order by transcript_date desc limit 1 | what is the date of transcript number 5?",
    "label": "CONFIRM_SQL",
    "output": "select transcript_date from transcripts where transcript_id = 5"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "is there any data providing who the transcript was recorded by? | Sorry, our databases do not have information on who recorded the transcripts. | ok, Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "network_1",
    "input": "Hello!  Can you see all of the ids of the high school students? | select student_id from friend | Oh sorry! Lost count of which question I was at with you... Can you tell me what the totals are for each of student ID, liked ID and friend ID?",
    "label": "CLARIFY",
    "output": "do you mean the total number of liked id and friend id for each student id?"
  },
  {
    "db_id": "network_1",
    "input": "Yes!  Exactly that please! | sorry, i cannot answer this question,can you give another related question？ thank you very much | How many total student IDs are there?",
    "label": "CONFIRM_SQL",
    "output": "select count ( student_id ) from ( select distinct student_id from friend union select distinct student_id from likes )"
  },
  {
    "db_id": "dog_kennels",
    "input": "Please list the emails of all the professionals who live in the state of Hawaii? | select email_address from professionals where state = 'Hawaii' | Please list the emails of all the professionals who live in the state of Wisconsin?",
    "label": "CONFIRM_SQL",
    "output": "select email_address from professionals where state = 'Wisconsin'"
  },
  {
    "db_id": "dog_kennels",
    "input": "Could you tell me the first names of all employees with the role code \" Employee\"? | select first_name from professionals where role_code = 'Employee' | Thanks!",
    "label": "WELCOME",
    "output": "welcome,goodbye"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Can you list the semester names and their enrollments? | select semesters.semester_name , count ( * ) from semesters join student_enrolment on semesters.semester_id = student_enrolment.semester_id group by student_enrolment.semester_id | Which semester has the most enrollments?",
    "label": "CONFIRM_SQL",
    "output": "select semesters.semester_name from semesters join student_enrolment on semesters.semester_id = student_enrolment.semester_id group by student_enrolment.semester_id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Can you list the student enrollment ids and the degree program ids? | select student_enrolment_id , degree_program_id from student_enrolment | Hmm, which semesters do not have any student enrolled? I want the semester names.",
    "label": "CONFIRM_SQL",
    "output": "select semester_name from semesters where semester_id not in ( select semester_id from student_enrolment )"
  },
  {
    "db_id": "world_1",
    "input": "What are all of the countries where English isn't the official language? | select name from country where name not in ( select country.name from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'English' and countrylanguage.isofficial = 'T' ) | What is the average life expectancy in each of those countries?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( lifeexpectancy ) from country where name not in ( select country.name from country join countrylanguage on country.code = countrylanguage.countrycode where countrylanguage.language = 'English' and countrylanguage.isofficial = 'T' )"
  },
  {
    "db_id": "flight_2",
    "input": "Find Flight from CVO to SNA | select flightno from flights where sourceairport = 'CVO' and destairport = 'SNA' | Flight from CVO to DFW",
    "label": "CONFIRM_SQL",
    "output": "select * from flights where sourceairport = 'CVO' and destairport = 'DFW'"
  },
  {
    "db_id": "flight_2",
    "input": "Which airlines have flight from CVO?\n | select airlines.airline from airlines join flights on airlines.uid = flights.airline where flights.sourceairport = ' CVO' | Thank\n",
    "label": "REQUEST_MORE",
    "output": "Sure! Do you want to know more?"
  },
  {
    "db_id": "tvshow",
    "input": "What is the TV Channel of TV series \"A love of a lifetime\"?\n | select tv_channel.series_name from tv_channel join tv_series on tv_channel.id = tv_series.channel where tv_series.episode = 'A Love of a Lifetime' | How may viewers does \"A love of a lifetime\" have?",
    "label": "CONFIRM_SQL",
    "output": "select viewers_m from tv_series where episode = 'A Love of a Lifetime'"
  },
  {
    "db_id": "tvshow",
    "input": "How about the rating of \"A love of a lifetime?\" | select weekly_rank from tv_series where episode = 'A Love of a Lifetime' | And when was \"A love of a lifetime\" aired?",
    "label": "CONFIRM_SQL",
    "output": "select air_date from tv_series where episode = 'A Love of a Lifetime'"
  },
  {
    "db_id": "wta_1",
    "input": "What is the player id for the youngest player? | select player_id from players order by birth_date desc limit 1 | What about the oldest?",
    "label": "CONFIRM_SQL",
    "output": "select player_id from players order by birth_date asc limit 1"
  },
  {
    "db_id": "wta_1",
    "input": "What is their first name and country code? | select first_name , country_code from players order by birth_date asc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, good bye. "
  },
  {
    "db_id": "course_teach",
    "input": "What're the names of the teachers who teach two or more courses? | select teacher.name from course_arrange join teacher on course_arrange.teacher_id = teacher.teacher_id group by teacher.name having count ( * ) >= 2 | What is her age and hometown?",
    "label": "CONFIRM_SQL",
    "output": "select teacher.age , teacher.hometown from course_arrange join teacher on course_arrange.teacher_id = teacher.teacher_id group by teacher.name having count ( * ) >= 2"
  },
  {
    "db_id": "course_teach",
    "input": "What grade does the oldest teacher teach? | select course_arrange.grade from course_arrange join teacher on course_arrange.teacher_id = teacher.teacher_id order by teacher.age desc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "battle_death",
    "input": "how many ships are there? | select count ( * ) from ship | what are their names?",
    "label": "CONFIRM_SQL",
    "output": "select name from ship"
  },
  {
    "db_id": "concert_singer",
    "input": "What is the name of the youngest singer? | select name from singer order by age asc limit 1 | What's the name of the song by Tribal King?",
    "label": "CONFIRM_SQL",
    "output": "select song_name from singer where name = 'Tribal King'"
  },
  {
    "db_id": "concert_singer",
    "input": "What was the release year of that song? | select song_release_year from singer where name = 'Tribal King' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye."
  },
  {
    "db_id": "world_1",
    "input": "Can you please list all the names of the countries that are in the continent of Europe? | select name from country where continent = 'Europe' | Can you please only show those countries with a population of 80000 in the table?",
    "label": "CONFIRM_SQL",
    "output": "select name from country where continent = 'Europe' and population = '80000'"
  },
  {
    "db_id": "singer",
    "input": "who is the singers name? | did you mean List the names of all singers | yes tell me singers name?",
    "label": "CONFIRM_SQL",
    "output": "select name from singer"
  },
  {
    "db_id": "singer",
    "input": "how much sales in christmas ? | sorry,i dont have the anwser you want | ok i say leave this chat..thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What is the full name of the department that has the substring computer in its name? | select department_name from departments where department_name like '%computer%' | What's the description of that department?",
    "label": "CONFIRM_SQL",
    "output": "select department_description from departments where department_name like '%computer%'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What is that department's id? | select department_id from departments where department_name like '%computer%' | Are there any other details about that department?",
    "label": "CONFIRM_SQL",
    "output": "select other_details from departments where department_name like '%computer%'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What about for history? | What do you mean exactly? | What are the other details for the department named history?",
    "label": "CONFIRM_SQL",
    "output": "select other_details from departments where department_name = 'history'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Are there any departments with other details that are not the word 'NULL' ? | select department_name from departments where other_details != 'NULL' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "car_1",
    "input": "how many cylinders in the cars_data table | select sum ( cylinders ) from cars_data | i want to highest weight in the cars_data table",
    "label": "CONFIRM_SQL",
    "output": "select weight from cars_data order by weight desc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "how many year in the cars_data table | select count ( * ) from cars_data | what is the highest accelerate in the cars_data table",
    "label": "CONFIRM_SQL",
    "output": "select accelerate from cars_data order by accelerate desc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "ok thanks | You are welcome. Anything more you'd like to know? | i want to highest edispl in the cars_data table",
    "label": "CONFIRM_SQL",
    "output": "select cars_data.horsepower from cars_data order by cars_data.accelerate desc limit 1"
  },
  {
    "db_id": "concert_singer",
    "input": "what is the age of Joe sharp  | select age from singer where name = 'Joe Sharp' | How many US Singers? ",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from singer where country = 'United States'"
  },
  {
    "db_id": "concert_singer",
    "input": "How many Male Singers? | select count ( * ) from singer where is_male = 'True' | Thank! for your kind reply .",
    "label": "GOOD_BYE",
    "output": "thanks. good bye."
  },
  {
    "db_id": "car_1",
    "input": "Which models are manufactured by the maker with the name \"General Motors\"? | select distinct model_list.model from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where car_makers.fullname = 'General Motors' | How about models that weight more than 3500?",
    "label": "CONFIRM_SQL",
    "output": "select distinct model_list.model from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where cars_data.weight > 3500"
  },
  {
    "db_id": "car_1",
    "input": "What is the make and model of the car with the largest horsepower? | select distinct model_list.model , car_makers.maker from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where car_makers.fullname = 'General Motors' order by cars_data.horsepower desc limit 1 | How many cars manufactured by General Motors get more than 15 mpg?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where car_makers.fullname = 'General Motors' and cars_data.mpg > 15"
  },
  {
    "db_id": "car_1",
    "input": "What is the make and model of the car manufactured by General Motors that gets the highest mpg? | select distinct car_names.make , car_names.model from car_names join model_list on car_names.model = model_list.model join car_makers on model_list.maker = car_makers.id join cars_data on car_names.makeid = cars_data.id where car_makers.fullname = 'General Motors' order by cars_data.mpg desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "network_1",
    "input": "How many students in this table? | select count ( * ) from highschooler | To find average grade of these students?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( grade ) from highschooler"
  },
  {
    "db_id": "network_1",
    "input": "Find top grade of the student? | select grade from highschooler order by grade desc limit 1 | Find the lowest  grade of the student?",
    "label": "CONFIRM_SQL",
    "output": "select grade from highschooler order by grade asc limit 1"
  },
  {
    "db_id": "car_1",
    "input": "What countries produced cars? | select countries.countryname from countries join car_makers on countries.countryid = car_makers.country | What country does not have a car maker?",
    "label": "CONFIRM_SQL",
    "output": "select countryname from countries except select countries.countryname from countries join car_makers on countries.countryid = car_makers.country"
  },
  {
    "db_id": "network_1",
    "input": "Can you show me a list of student IDs and their friends IDs? | select student_id , friend_id from friend | Can you show me a list of all student IDs?",
    "label": "CLARIFY",
    "output": "Did you mean the id of all High schoolers?"
  },
  {
    "db_id": "network_1",
    "input": "Yes | select id from highschooler | Can you show a list of IDs that are on the second list, but are not on the first list?",
    "label": "CONFIRM_SQL",
    "output": "select id from highschooler where id not in ( select student_id from friend union select friend_id from friend )"
  },
  {
    "db_id": "network_1",
    "input": "Can you tell me the total number of student IDs? | select count ( id ) from highschooler | Can you tell me the total number of Friend IDs?",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct friend_id ) from friend"
  },
  {
    "db_id": "network_1",
    "input": "Can you tell me which Student ID is not on the list of Friend IDs? | by student id, do you mean the student id in the table friend or all high schoolers' ids. | All high schoolers' ids",
    "label": "CONFIRM_SQL",
    "output": "select id from highschooler except select friend_id from friend"
  },
  {
    "db_id": "network_1",
    "input": "Can you tell me the name and the grade of student ID 1510? | select name , grade from highschooler where id = 1510 | Thanks!",
    "label": "WELCOME",
    "output": "you are welcome, bye!"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "Hello!  Can you please provide me with a list of all of the cities in this database? | select city from employee | Great!  Can you update this list to show only the cities with more than one employee under the age of 30?",
    "label": "CONFIRM_SQL",
    "output": "select city from employee where age < 30 group by city having count ( * ) > 1"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "Yay!  Thank you!  Can you update this list to include the ages of all residents of Bath? | select age from employee where city = 'Bath' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "pets_1",
    "input": "How many students in the \"Student\" table are over the age of 20? | select count ( * ) from student where age > 20 | How many of those students own pets?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from student join has_pet on student.stuid = has_pet.stuid where student.age > 20"
  },
  {
    "db_id": "wta_1",
    "input": "Tell me the loser_name whose age is 24.626967830300003  | select distinct loser_name from matches where loser_age = 24.626967830300003 | Tell me the total number of matches played by Petra Kvitova...",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from matches where loser_name = 'Petra Kvitova' or winner_name = 'Petra Kvitova'"
  },
  {
    "db_id": "wta_1",
    "input": "Who has high loser_rank_points higher than 3500 ? | What attributes of the people  with loser_rank_points higher than 3500 would you like to know?  | based on loser_id",
    "label": "CONFIRM_SQL",
    "output": "select distinct loser_id from matches where loser_rank_points > 3500"
  },
  {
    "db_id": "wta_1",
    "input": "Find the name and rank points of the winner who won the most times... | select winner_name , winner_rank_points from matches group by winner_name order by count ( * ) desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you, goodbye. "
  },
  {
    "db_id": "network_1",
    "input": "What are the names of all of the high schoolers? | select name from highschooler | What is the value of the greatest number of likes for each high schooler?",
    "label": "CLARIFY",
    "output": "what  did  you mean  the value?"
  },
  {
    "db_id": "network_1",
    "input": "Sorry, the amount of the greatest number of likes. | select count ( * ) from likes group by student_id order by count ( * ) desc limit 1 | What is the name of the high schooler who has the greatest number of likes?",
    "label": "CONFIRM_SQL",
    "output": "select highschooler.name from likes join highschooler on likes.student_id = highschooler.id group by likes.student_id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "network_1",
    "input": "Thanks! | do  you  have more  question? | No.",
    "label": "WELCOME",
    "output": "welcome  and  bye "
  },
  {
    "db_id": "real_estate_properties",
    "input": "What is the feature type name of the feature AirCon? | select ref_feature_types.feature_type_name from other_available_features join ref_feature_types on other_available_features.feature_type_code = ref_feature_types.feature_type_code where other_available_features.feature_name = 'AirCon' | What is the full feature description of the feature name AirCon?",
    "label": "CONFIRM_SQL",
    "output": "select feature_description from other_available_features where feature_name = 'AirCon'"
  },
  {
    "db_id": "real_estate_properties",
    "input": "How many different feature IDs are there? | select count ( * ) from ( select distinct feature_id from other_available_features ) | What sort of feature type code is associated with AirCon?",
    "label": "CONFIRM_SQL",
    "output": "select feature_type_code from other_available_features where feature_name = 'AirCon'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Can you list the transcript date that appears least often? | select transcript_date from transcripts group by transcript_date order by count ( * ) asc limit 1 | How many times does the transcript date 1975-05-06 12:04:47\tshow up in the table?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from transcripts where transcript_date = '1975-05-06 12:04:47'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Which transcript date shows up the most number of times? | select transcript_date from transcripts group by transcript_date order by count ( * ) desc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "You're welcome. Bye!"
  },
  {
    "db_id": "flight_2",
    "input": "What is the destination of airline United Airlines? | Sorry, I cannot understand. Can you rephrase your question? | What is the destination airport of  United Airlines?",
    "label": "CONFIRM_SQL",
    "output": "select flights.destairport from airlines join flights on airlines.uid = flights.airline where airlines.airline = 'United Airlines'"
  },
  {
    "db_id": "flight_2",
    "input": "How many airlines have flights departing from APG? | select count ( airlines.airline ) from airlines join flights on airlines.uid = flights.airline where flights.sourceairport like '%APG%' | What is the flight number of Delta Airlines",
    "label": "CLARIFY",
    "output": "Did you mean to ask for the flight numbers of all flights on Delta Airlines?"
  },
  {
    "db_id": "flight_2",
    "input": "yes flight numbers of all flights on Delta Airlines | select flights.flightno from airlines join flights on airlines.uid = flights.airline where airlines.airline = 'Delta Airlines' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome. Good bye!"
  },
  {
    "db_id": "car_1",
    "input": "how many car models are produced in the USA? | select count ( * ) from model_list join car_makers on model_list.maker = car_makers.id join countries on car_makers.country = countries.countryid where countries.countryname = 'usa' | which companies produce those models?",
    "label": "CONFIRM_SQL",
    "output": "select distinct car_makers.maker from car_makers join countries on car_makers.country = countries.countryid where countries.countryname = 'usa'"
  },
  {
    "db_id": "car_1",
    "input": "how many Models has Ford produced? | select count ( * ) from model_list join car_makers where model_list.maker = car_makers.id and car_makers.maker = 'ford' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "flight_2",
    "input": "what is the dest airport of airline 1 | select destairport from flights where airline = '1' | what is the country of united airlines",
    "label": "CONFIRM_SQL",
    "output": "select country from airlines where airline = 'United Airlines'"
  },
  {
    "db_id": "flight_2",
    "input": "what is the source airport of ASY | What is ASY? | dest airport",
    "label": "CONFIRM_SQL",
    "output": "select sourceairport from flights where destairport = 'ASY'"
  },
  {
    "db_id": "flight_2",
    "input": "what is the country of us airways | select country from airlines where airline = 'US Airways' | what is the airline of country usa",
    "label": "CONFIRM_SQL",
    "output": "select airline from airlines where country = 'USA'"
  },
  {
    "db_id": "network_1",
    "input": "what is the average of grades? | select avg ( grade ) from highschooler | what is the name of higshoolers that starting with 'A'?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( grade ) from highschooler"
  },
  {
    "db_id": "network_1",
    "input": "what is the best grade ? | Did you mean to ask for the highest grade? | yes\n",
    "label": "CONFIRM_SQL",
    "output": "select max ( grade ) from highschooler"
  },
  {
    "db_id": "poker_player",
    "input": "Can you list all the names of the poker players ordered by the final tables in ascending order please? | select people.name from people join poker_player on people.people_id = poker_player.people_id order by poker_player.final_table_made asc | What are the nationalities of the poker players ordered by the final tables in ascending order?",
    "label": "CONFIRM_SQL",
    "output": "select people.nationality from people join poker_player on people.people_id = poker_player.people_id order by poker_player.final_table_made asc"
  },
  {
    "db_id": "poker_player",
    "input": "What is the name of the poker player with the highest earnings? | select people.name from people join poker_player on people.people_id = poker_player.people_id order by poker_player.earnings desc limit 1 | What about the poker player with the lowest earnings?",
    "label": "CONFIRM_SQL",
    "output": "select people.name from people join poker_player on people.people_id = poker_player.people_id order by poker_player.earnings asc limit 1"
  },
  {
    "db_id": "poker_player",
    "input": "What was his best finish? | select poker_player.best_finish from people join poker_player on people.people_id = poker_player.people_id order by poker_player.earnings asc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What are the release dates for transcripts?\n | select transcript_date from transcripts | What is the most recent date for release of transcripts?",
    "label": "CONFIRM_SQL",
    "output": "select transcript_date from transcripts order by transcript_date desc limit 1"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What is the last transcript release date?\n | select transcript_date from transcripts order by transcript_date desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "tvshow",
    "input": "which is the most recently aired cartoon?\n | select title from cartoon order by original_air_date asc limit 1 | find the channel of the most recently aired cartoon.",
    "label": "CONFIRM_SQL",
    "output": "select channel from cartoon order by original_air_date asc limit 1"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "What is the version number of template id 3? | select version_number from templates where template_id = 3 | What is the document name of template id 25?",
    "label": "CONFIRM_SQL",
    "output": "select documents.document_name from templates join documents on templates.template_id = documents.template_id where templates.template_id = 25"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Show all template types codes that are not used by any document? | select template_type_code from templates except select template_type_code from templates join documents on templates.template_id = documents.template_id | What is the version number of template id 4?",
    "label": "CONFIRM_SQL",
    "output": "select version_number from templates where template_id = 4"
  },
  {
    "db_id": "flight_2",
    "input": "Can you list all the flight numbers that have a source airport value of AHD? | select flightno from flights where sourceairport = 'AHD' | Interesting, can you tell me if there is any airport with a value of AHD, and if that value appears anywhere in the table at all?",
    "label": "CONFIRM_SQL",
    "output": "select flightno from flights where sourceairport = ' AHD'"
  },
  {
    "db_id": "flight_2",
    "input": "Can you list the names of all the unique airlines that belong to those flight numbers? | select airlines.airline from airlines join flights on airlines.uid = flights.airline where flights.sourceairport = ' AHD' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye."
  },
  {
    "db_id": "concert_singer",
    "input": "How many stadiums can accommodate more than 1000 people in average.? | select count ( * ) from stadium where average > 1000 | What is the name of the stadium with the highest average  lowest attendance?",
    "label": "CLARIFY",
    "output": "Sorry, I don't understand \"highest average lowest attendance\". Could you please clarify?"
  },
  {
    "db_id": "concert_singer",
    "input": "sorry , What is the name of the stadium with the lowest attendance in average.? | select name from stadium order by average asc limit 1 | What about the one with highest average attendance?",
    "label": "CONFIRM_SQL",
    "output": "select name from stadium order by average desc limit 1"
  },
  {
    "db_id": "world_1",
    "input": "Which African countries have a smaller population than that of any Asian country? | select name from country where continent = 'Africa' and population < ( select min ( population ) from country where continent = 'Asia' ) | Which Asian countries have a smaller population than that of any African country?",
    "label": "CONFIRM_SQL",
    "output": "select name from country where continent = 'Asia' and population < ( select min ( population ) from country where continent = 'Africa' )"
  },
  {
    "db_id": "world_1",
    "input": "Which Asian country has the highest life expectancy? | select name from country where continent = 'Asia' order by lifeexpectancy desc limit 1 | Thank you!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "dog_kennels",
    "input": "Hello!  Can you tell me how many dogs have not gone through any treatment? | select count ( * ) from dogs where dog_id not in ( select dog_id from treatments ) | Thank you for that!  Can you tell me how many of these dogs were abandoned?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from dogs where abandoned_yn = 1 and dog_id not in ( select dog_id from treatments )"
  },
  {
    "db_id": "dog_kennels",
    "input": "Can you provide me with a list of all dog Ids for all of the abandoned dogs, as well as their associated treatment type code? | select dogs.dog_id , treatments.treatment_type_code from dogs join treatments on dogs.dog_id = treatments.dog_id where abandoned_yn = 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "No problem, bye"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "did you mean the total amount of bonuses that employee got? | yes, thx! | how old is George Chuter?",
    "label": "CONFIRM_SQL",
    "output": "select age from employee where name = 'George Chuter'"
  },
  {
    "db_id": "employee_hire_evaluation",
    "input": "how much bonus was Employee with ID 1 awarded? | select sum ( bonus ) from evaluation where employee_id = 1 | What city is Lee Mears from?",
    "label": "CONFIRM_SQL",
    "output": "select city from employee where name = 'Lee Mears'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Find the program which most number of students are enrolled in. List both the id and the summary. | select degree_programs.degree_program_id , degree_programs.degree_summary_name from degree_programs join student_enrolment on degree_programs.degree_program_id = student_enrolment.degree_program_id group by degree_programs.degree_program_id order by count ( * ) desc limit 1 | for id program 9, which degree summary is the most common",
    "label": "CLARIFY",
    "output": "Could you please clarify your question? Since one program has only one degree summary."
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "which program has the most students\n | select degree_programs.degree_program_id from degree_programs join student_enrolment on degree_programs.degree_program_id = student_enrolment.degree_program_id group by degree_programs.degree_program_id order by count ( * ) desc limit 1 | How many students are in program 9\n",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from student_enrolment where degree_program_id = '9'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "how many master are in program 9 | select count ( * ) from degree_programs where degree_summary_name = 'Master' and degree_program_id = '9' | which program has the least students",
    "label": "CONFIRM_SQL",
    "output": "select degree_programs.degree_program_id , degree_programs.degree_summary_name from degree_programs join student_enrolment on degree_programs.degree_program_id = student_enrolment.degree_program_id group by degree_programs.degree_program_id order by count ( * ) asc limit 1"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "how many students does id 3 have | select count ( * ) from student_enrolment where degree_program_id = '3' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "car_1",
    "input": "Show me continent IDs of each continent | select contid , continent from continents | Show me continent names and the number of countries they have",
    "label": "CONFIRM_SQL",
    "output": "select continents.continent , count ( * ) from continents join countries on continents.contid = countries.continent group by continents.contid"
  },
  {
    "db_id": "car_1",
    "input": "Which continent has the highest number of countries? | select continents.continent , count ( * ) from continents join countries on continents.contid = countries.continent group by continents.contid order by count ( * ) desc limit 1 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you!  Goodbye."
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Hello!  How are you?  First, I'll start with a straightforward request...  Can you show me all document IDs and their corresponding document names and number of paragraphs? | select paragraphs.document_id , documents.document_name , count ( * ) from paragraphs join documents on paragraphs.document_id = documents.document_id group by paragraphs.document_id | Thank you!  Can you update this list to show only the Document_IDs and corresponding document_names for the documents that have 2 or more paragraphs, and then add the values from the paragraph text category?",
    "label": "REJECT",
    "output": "Sorry, I do not understand your question."
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Okay...  I'll ask something different.  Can you show me a list of all of the paragraph text values? | select paragraph_text from paragraphs | Thanks!  Can you filter this list to show the Paragraph_Texts which have something other than \"NULL\" as the Other Details?",
    "label": "CONFIRM_SQL",
    "output": "select paragraph_text from paragraphs where other_details != 'NULL'"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Thanks! | Do you have any more questions? | I don't think so...  Thank you for you time!",
    "label": "GOOD_BYE",
    "output": "Goodbye!"
  },
  {
    "db_id": "tvshow",
    "input": "Hello!  Can you provide me with a list of all cartoons written by Todd Casey? | select * from cartoon where written_by = 'Todd Casey' | Can you update the list to show only those Titles which are cartoons?",
    "label": "CONFIRM_SQL",
    "output": "select title from cartoon where written_by = 'Todd Casey'"
  },
  {
    "db_id": "tvshow",
    "input": "Can you update this list to include the corresponding television channel? | select tv_channel.id from tv_channel join cartoon on tv_channel.id = cartoon.channel where cartoon.written_by = 'Todd Casey' | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "museum_visit",
    "input": "Can you tell me the total amount spent on tickets by visitors with membership level 1? | select sum ( visit.total_spent ) from visitor join visit on visitor.id = visit.visitor_id where visitor.level_of_membership = 1 | Can you tell me how many visitors there are at membership level 1?",
    "label": "CONFIRM_SQL",
    "output": "select count ( id ) from visitor where level_of_membership = 1"
  },
  {
    "db_id": "museum_visit",
    "input": "How many membership levels are there? | select count ( distinct level_of_membership ) from visitor | Can you show me the names of each visitor with membership level 1?",
    "label": "CONFIRM_SQL",
    "output": "select name from visitor where level_of_membership = 1"
  },
  {
    "db_id": "museum_visit",
    "input": "I'd like to know how much was spent on tickets at each membership level, can you show me? | select visitor.level_of_membership , sum ( total_spent ) from visitor join visit on visitor.id = visit.visitor_id group by level_of_membership | Thanks!",
    "label": "GOOD_BYE",
    "output": "No problem. bye!"
  },
  {
    "db_id": "wta_1",
    "input": "what is the first name of player id 200001? | select first_name from players where player_id = 200001 | When is birth date for Martina ?",
    "label": "CLARIFY",
    "output": "There are a lot of Martina. Do you mean the Marina with id 200001? "
  },
  {
    "db_id": "wta_1",
    "input": "Martina with id 200001 | select birth_date from players where player_id = 200001 | * I have left the chat *",
    "label": "INFORM_SQL",
    "output": "what is the country code for player id 200003?\n"
  },
  {
    "db_id": "wta_1",
    "input": "select country_code from players where player_id = 200003 | what is the last name of Justine of player id 200003? | select last_name from players where player_id = 200003",
    "label": "THANK_YOU",
    "output": "thanks."
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "How many ids are in document 'Welcome to NY'? | Do you mean how many paragraphs are associated with document 'Welcome to NY'? | yes\n",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from paragraphs join documents on paragraphs.document_id = documents.document_id where documents.document_name = 'Welcome to NY'"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "What are their texts? | select paragraphs.paragraph_text from paragraphs join documents on paragraphs.document_id = documents.document_id where documents.document_name = 'Welcome to NY' | What are their id numbers?",
    "label": "CONFIRM_SQL",
    "output": "select paragraphs.paragraph_id from paragraphs join documents on paragraphs.document_id = documents.document_id where documents.document_name = 'Welcome to NY'"
  },
  {
    "db_id": "wta_1",
    "input": "find the total ranking point for each player and their first name | select sum ( ranking_points ) , players.first_name from players join rankings on players.player_id = rankings.player_id group by players.first_name | which player got first rank and their name",
    "label": "CLARIFY",
    "output": "Do you want the first name or last name?"
  },
  {
    "db_id": "wta_1",
    "input": "first name | select distinct players.first_name from players join rankings on players.player_id = rankings.player_id where rankings.ranking = 1 | is this correct?",
    "label": "CONFIRM_SQL",
    "output": "select distinct players.first_name , rankings.ranking from players join rankings on players.player_id = rankings.player_id where rankings.ranking = 1"
  },
  {
    "db_id": "world_1",
    "input": "What African country has the largest population? | select name from country where continent = 'Africa' order by population desc limit 1 | And what is the population of Nigeria?\n",
    "label": "CONFIRM_SQL",
    "output": "select population from country where name = 'Nigeria'"
  },
  {
    "db_id": "world_1",
    "input": "What Asian country has the largest population? | select name from country where continent = 'Asia' order by population desc limit 1 | What is China's population?\n",
    "label": "CONFIRM_SQL",
    "output": "select population from country where name = 'China'"
  },
  {
    "db_id": "world_1",
    "input": "How many Asian countries have a population greater than that of Nigeria? | select count ( name ) from country where continent = 'Asia' and population > ( select population from country where name = 'Nigeria' ) | Can you list those countries?\n",
    "label": "CONFIRM_SQL",
    "output": "select name from country where continent = 'Asia' and population > ( select population from country where name = 'Nigeria' )"
  },
  {
    "db_id": "world_1",
    "input": "Which unique cities are in Asian countries? | select distinct city.name from country join countrylanguage on country.code = countrylanguage.countrycode join city on country.code = city.countrycode where country.continent = 'Asia' | Which of those cities have Chinese as their official language?",
    "label": "CONFIRM_SQL",
    "output": "select distinct city.name from country join countrylanguage on country.code = countrylanguage.countrycode join city on country.code = city.countrycode where countrylanguage.isofficial = 'T' and countrylanguage.language = 'Chinese' and country.continent = 'Asia'"
  },
  {
    "db_id": "world_1",
    "input": "Which of those cities have a population over 200,000? | select distinct city.name from country join countrylanguage on country.code = countrylanguage.countrycode join city on country.code = city.countrycode where city.population > 200000 | What is the average population of all cities in China?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( city.population ) from country join countrylanguage on country.code = countrylanguage.countrycode join city on country.code = city.countrycode where country.name = 'China'"
  },
  {
    "db_id": "world_1",
    "input": "What is the average population of all cities that speak the Dutch language? | select avg ( city.population ) from country join countrylanguage on country.code = countrylanguage.countrycode join city on country.code = city.countrycode where countrylanguage.language = 'Dutch' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "museum_visit",
    "input": "How many customers are there? | Sorry, I can not answer that question based on this table.  | How many visitors are ther?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from visitor"
  },
  {
    "db_id": "museum_visit",
    "input": "How many of them have membership levels higher than 4? | select count ( * ) from visitor where level_of_membership > 4 | Can you please list their names?",
    "label": "CONFIRM_SQL",
    "output": "select name from visitor where level_of_membership > 4"
  },
  {
    "db_id": "museum_visit",
    "input": "Can you rank them by their membership level from high to low? | select name from visitor where level_of_membership > 4 order by level_of_membership desc | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you,  good bye. "
  },
  {
    "db_id": "wta_1",
    "input": "Could you list the average ranking for each player with their first name? | select avg ( ranking ) , players.first_name from players join rankings on players.player_id = rankings.player_id group by players.player_id | Could you add in their last names please?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( ranking ) , players.first_name , players.last_name from players join rankings on players.player_id = rankings.player_id group by players.player_id"
  },
  {
    "db_id": "wta_1",
    "input": "What are the full names of all left-handed players (hand value \"L\")? | select players.first_name , players.last_name from players where players.hand = 'L' | Could you just show their last names, please?",
    "label": "CONFIRM_SQL",
    "output": "select players.last_name from players where players.hand = 'L'"
  },
  {
    "db_id": "wta_1",
    "input": "Would you also add in their rankings? | Do you mean their average rankings? | Yes, please.",
    "label": "CONFIRM_SQL",
    "output": "select avg ( ranking ) , players.last_name from players join rankings on players.player_id = rankings.player_id where players.hand = 'L' group by players.first_name"
  },
  {
    "db_id": "network_1",
    "input": "What is the average grade of all students who have some friends, please? | select avg ( grade ) from highschooler where id in ( select friend.student_id from friend join highschooler on friend.student_id = highschooler.id ) | Are there any students that have no friends?",
    "label": "CONFIRM_SQL",
    "output": "select * from highschooler where id not in ( select student_id from friend )"
  },
  {
    "db_id": "network_1",
    "input": "What are their grades? | select grade from highschooler where id not in ( select student_id from friend ) | What are their names?",
    "label": "CONFIRM_SQL",
    "output": "select name from highschooler where id not in ( select student_id from friend )"
  },
  {
    "db_id": "network_1",
    "input": "What are the names of the students with friends? | select name from highschooler where id in ( select student_id from friend ) | Thanks!",
    "label": "WELCOME",
    "output": "Sure! Bye!"
  },
  {
    "db_id": "network_1",
    "input": "Did you mean the number of likes Kyle has? | Yes | How many students are there?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from highschooler"
  },
  {
    "db_id": "network_1",
    "input": "How many students have grade 9 | select count ( * ) from highschooler where grade = 9 | Is Kyle one of them?",
    "label": "CONFIRM_SQL",
    "output": "select name from highschooler where grade = 9"
  },
  {
    "db_id": "network_1",
    "input": "What is his grade? | select grade from highschooler where name = 'Kyle' | What about his likes?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from likes join highschooler on likes.student_id = highschooler.id where highschooler.name = 'Kyle'"
  },
  {
    "db_id": "concert_singer",
    "input": "show the stadium names without any concern | select name from stadium where stadium_id not in ( select stadium_id from concert ) | which is the most famous stadium?\n",
    "label": "CLARIFY",
    "output": "By which metric do you mean famous?"
  },
  {
    "db_id": "concert_singer",
    "input": "football stadium | select name from stadium order by highest desc limit 1 | yes\n",
    "label": "CONFIRM_SQL",
    "output": "select name from stadium order by highest desc limit 1"
  },
  {
    "db_id": "singer",
    "input": "What is the most common citizenship of singers, please? | select citizenship from singer group by citizenship order by count ( * ) desc limit 1 | What about the least common?",
    "label": "CONFIRM_SQL",
    "output": "select citizenship from singer group by citizenship order by count ( * ) asc limit 1"
  },
  {
    "db_id": "singer",
    "input": "What are the names of all the singers from Australia, please? | select name from singer where citizenship = 'Australia' | Thanks!",
    "label": "REQUEST_MORE",
    "output": "Sure! Anything else?"
  },
  {
    "db_id": "poker_player",
    "input": "To which nationality does the people_id 1 belongs to ? | select nationality from people where people_id = 1 | Tell me the birthday date of Teodor Salparov ?",
    "label": "CONFIRM_SQL",
    "output": "select birth_date from people where name = 'Teodor Salparov'"
  },
  {
    "db_id": "poker_player",
    "input": "Tell me the earnings of the people id 5?\n | select earnings from poker_player where people_id = 5 | What is the money rank of the tallest poker player ?",
    "label": "CONFIRM_SQL",
    "output": "select poker_player.money_rank from people join poker_player on people.people_id = poker_player.people_id order by people.height desc limit 1"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Which program had the least number of students enrolled? | select degree_programs.degree_summary_name from degree_programs join student_enrolment on degree_programs.degree_program_id = student_enrolment.degree_program_id group by degree_programs.degree_summary_name order by count ( * ) desc limit 1 | what is the average  number of students enrolled in all programs?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( ct ) from ( select count ( student_enrolment_id ) as ct from student_enrolment group by degree_program_id )"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What is the degree ID for architecto? | select degree_program_id from degree_programs where degree_summary_description = 'architecto' | What about camque?",
    "label": "CONFIRM_SQL",
    "output": "select degree_program_id from degree_programs where degree_summary_description = 'camque'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Which programs has the student by the first name Timmothy enrolled? | select student_enrolment.degree_program_id from students join student_enrolment on students.student_id = student_enrolment.student_id where students.first_name = 'Timmothy' | Which date did he register and also which date did he leave?",
    "label": "CONFIRM_SQL",
    "output": "select date_first_registered , date_left from students where first_name = 'Timmothy'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What is the middle name of the student with email address johns.unique@example.net? | select middle_name from students where email_address = 'johns.unique@example.net' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome. Good bye!"
  },
  {
    "db_id": "pets_1",
    "input": "Hi. What are the different types of pets? | select distinct pettype from pets | Between the cats and dogs, how many of them are dogs?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from pets where pettype = 'dog'"
  },
  {
    "db_id": "pets_1",
    "input": "What are the ages of the 2 dogs? | select pet_age from pets where pettype = 'dog' | How much does the youngest dog, the 1 year old, weigh?",
    "label": "CONFIRM_SQL",
    "output": "select weight from pets where pettype = 'dog' and pet_age = ( select min ( pet_age ) from pets where pettype = 'dog' )"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Could you tell me the last names of all the students who live in the state of North Carolina? | select students.last_name from students join addresses on students.current_address_id = addresses.address_id where addresses.state_province_county = 'NorthCarolina' | What about their first names?",
    "label": "CONFIRM_SQL",
    "output": "select students.first_name from students join addresses on students.current_address_id = addresses.address_id where addresses.state_province_county = 'NorthCarolina'"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What are the last names of the students who live in North Carolina but have not registered in any degree program? | select students.last_name from students join addresses on students.current_address_id = addresses.address_id where addresses.state_province_county = 'NorthCarolina' except select distinct students.last_name from students join student_enrolment on students.student_id = student_enrolment.student_id | What are their first names?",
    "label": "CONFIRM_SQL",
    "output": "select students.first_name from students join addresses on students.current_address_id = addresses.address_id where addresses.state_province_county = 'NorthCarolina' except select distinct students.last_name from students join student_enrolment on students.student_id = student_enrolment.student_id"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What are the dates first registered of all students from the country Iceland? | select students.date_first_registered from students join addresses on students.current_address_id = addresses.address_id where addresses.country = 'Iceland' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye"
  },
  {
    "db_id": "wta_1",
    "input": "find the name of loser and winner who played in the match with the greatest number of minutes | select winner_name , loser_name from matches order by minutes desc limit 1 | what were the player's scores?",
    "label": "CONFIRM_SQL",
    "output": "select score from matches order by minutes desc limit 1"
  },
  {
    "db_id": "wta_1",
    "input": "which games did they participate in? | What information about the game do you need? | Thanks!",
    "label": "GOOD_BYE",
    "output": "Bye!"
  },
  {
    "db_id": "car_1",
    "input": "What are all the car models available?  | select distinct model from car_names | Which of those distinct models are produced after 1980?",
    "label": "CONFIRM_SQL",
    "output": "select distinct model_list.model from model_list join car_names on model_list.model = car_names.model join cars_data on car_names.makeid = cars_data.id where cars_data.year > 1980"
  },
  {
    "db_id": "network_1",
    "input": "which grade has the \nmost high schoolers | select grade from highschooler group by grade order by count ( * ) desc limit 1 | what are the name of high schoolers in grade 9\n",
    "label": "CONFIRM_SQL",
    "output": "select name from highschooler where grade = 9"
  },
  {
    "db_id": "network_1",
    "input": "what grade is tiffany\n | select grade from highschooler where name = 'Tiffany' | how many high schoolers in grade 9\n",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from highschooler where grade = 9"
  },
  {
    "db_id": "network_1",
    "input": "what grade is gabriel | Did you mean the Gabriel with ID 1689? | yes",
    "label": "CONFIRM_SQL",
    "output": "select grade from highschooler where name = 'Gabriel' and id = 1689"
  },
  {
    "db_id": "network_1",
    "input": "What ID is Tiffany? | select id from highschooler where name = 'Tiffany' | Which high schooler has ID of 1510?",
    "label": "CONFIRM_SQL",
    "output": "select name from highschooler where id = 1510"
  },
  {
    "db_id": "dog_kennels",
    "input": "Show  me the first and last name whose id number 1 | Do you mean the owner id is 1 or dog id is 1? | owner id please.",
    "label": "CONFIRM_SQL",
    "output": "select owners.first_name , owners.last_name from owners join dogs on owners.owner_id = dogs.owner_id where owners.owner_id = 1"
  },
  {
    "db_id": "dog_kennels",
    "input": " name the dog which  aged 6? | select name from dogs where age = 6 | name the dog having age more than 5",
    "label": "CONFIRM_SQL",
    "output": "select name from dogs where age > 5"
  },
  {
    "db_id": "dog_kennels",
    "input": "which dogs are owned by someone who lives in virginia? List the name. | select dogs.name from owners join dogs on owners.owner_id = dogs.owner_id where owners.state = 'Virginia' | Thanks!",
    "label": "THANK_YOU",
    "output": "* I have left the chat *"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "Which cause has the least enrollment? | Do you want the course id or course name? | the course name",
    "label": "CONFIRM_SQL",
    "output": "select courses.course_name from courses join student_enrolment_courses on courses.course_id = student_enrolment_courses.course_id group by courses.course_name order by count ( * ) asc limit 1"
  },
  {
    "db_id": "student_transcripts_tracking",
    "input": "What is the course ID of Math? | select course_id from courses where course_name = 'math' | How many students enrolled a course with the id of 14",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from courses join student_enrolment_courses on courses.course_id = student_enrolment_courses.course_id group by courses.course_name having courses.course_id = 14"
  },
  {
    "db_id": "world_1",
    "input": "how many population in the country table | Do  you mean  the  total population in the country table ? | how many country code in the city table",
    "label": "CLARIFY",
    "output": "Do  you  want  to  know  the distinct country code?"
  },
  {
    "db_id": "world_1",
    "input": "how many language in the countrylanguage table | select count ( distinct language ) from countrylanguage | what the highest percentage in the countrylanguage table",
    "label": "CONFIRM_SQL",
    "output": "select max ( percentage ) from countrylanguage"
  },
  {
    "db_id": "network_1",
    "input": "Show the names of all of the high schoolers. | select name from highschooler | Which of the high schoolers are friends with Kyle?",
    "label": "CLARIFY",
    "output": "Do you want the name of the high schoolers that are friends with Kyle?"
  },
  {
    "db_id": "network_1",
    "input": "Yes, I do. | select highschooler.name from friend join highschooler on friend.student_id = highschooler.id join highschooler on friend.friend_id = highschooler.id where highschooler.name = 'Kyle' | What is Kyle's ID?",
    "label": "CONFIRM_SQL",
    "output": "select id from highschooler where name = 'Kyle'"
  },
  {
    "db_id": "network_1",
    "input": "Who has the ID 1709? | select name from highschooler where id = 1709 | Who else is Jordan friends with?",
    "label": "CONFIRM_SQL",
    "output": "select highschooler.name from friend join highschooler on friend.student_id = highschooler.id join highschooler on friend.friend_id = highschooler.id where highschooler.name = 'Jordan'"
  },
  {
    "db_id": "network_1",
    "input": "Who is friends with Gabriel? | select highschooler.name from friend join highschooler on friend.student_id = highschooler.id join highschooler on friend.friend_id = highschooler.id where highschooler.name = 'Gabriel' | Okay, thank you.",
    "label": "GOOD_BYE",
    "output": "Thank you. Bye"
  },
  {
    "db_id": "car_1",
    "input": "Hi! which countries are in europe? | select distinct countries.countryname from countries join continents on countries.continent = continents.contid join car_makers on countries.countryid = car_makers.country where continents.continent = 'europe' | How many car manufacturers are in each of those countries?",
    "label": "CONFIRM_SQL",
    "output": "select countries.countryname , count ( * ) from countries join continents on countries.continent = continents.contid join car_makers on countries.countryid = car_makers.country where continents.continent = 'europe' group by countries.countryname"
  },
  {
    "db_id": "car_1",
    "input": "which of those has at least 3? | select countries.countryname from countries join continents on countries.continent = continents.contid join car_makers on countries.countryid = car_makers.country where continents.continent = 'europe' group by countries.countryname having count ( * ) >= 3 | how many do each of those have?",
    "label": "CONFIRM_SQL",
    "output": "select countries.countryname , count ( * ) from countries join continents on countries.continent = continents.contid join car_makers on countries.countryid = car_makers.country where continents.continent = 'europe' group by countries.countryname having count ( * ) >= 3"
  },
  {
    "db_id": "car_1",
    "input": "how many total car manufacturers does europe have? | select count ( * ) from countries join continents on countries.continent = continents.contid join car_makers on countries.countryid = car_makers.country where continents.continent = 'europe' | what about america?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from countries join continents on countries.continent = continents.contid join car_makers on countries.countryid = car_makers.country where continents.continent = 'america'"
  },
  {
    "db_id": "car_1",
    "input": "what are those? | select car_makers.fullname from countries join continents on countries.continent = continents.contid join car_makers on countries.countryid = car_makers.country where continents.continent = 'america' | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "museum_visit",
    "input": "Hello there!  Can you tell me the total number of visitors who did not visit any museum that was opened after 2010? | select count ( * ) from visitor where id not in ( select visit.visitor_id from museum join visit on museum.museum_id = visit.museum_id where museum.open_year > 2010 ) | Can you please provide me with the names and membership levels of these three members?",
    "label": "CONFIRM_SQL",
    "output": "select name , level_of_membership from visitor where id not in ( select visit.visitor_id from museum join visit on museum.museum_id = visit.museum_id where museum.open_year > 2010 )"
  },
  {
    "db_id": "dog_kennels",
    "input": "Hi! How many owners temporarily do not have dogs? | select count ( * ) from owners where owner_id not in ( select owner_id from dogs ) | What are their full names?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from owners where owner_id not in ( select owner_id from dogs )"
  },
  {
    "db_id": "dog_kennels",
    "input": "SELECT first_name, last_name FROM Owners WHERE owner_id NOT IN ( SELECT owner_id FROM Dogs ) | Did they abandon their dogs (abandoned yes or no)? | select abandoned_yn from dogs where owner_id in ( select owner_id from owners where owner_id not in ( select owner_id from dogs ) )",
    "label": "THANK_YOU",
    "output": "Good! Doggies are too cute to be abandoned. Thank you!"
  },
  {
    "db_id": "tvshow",
    "input": "Which cartoon aired first?\n | select title from cartoon order by original_air_date asc limit 1 | What was the last cartoon to air?",
    "label": "CONFIRM_SQL",
    "output": "select title from cartoon order by original_air_date desc limit 1"
  },
  {
    "db_id": "tvshow",
    "input": "What channel was it on? | select channel from cartoon order by original_air_date desc limit 1 | What is the production code?",
    "label": "CONFIRM_SQL",
    "output": "select production_code from cartoon order by original_air_date desc limit 1"
  },
  {
    "db_id": "singer",
    "input": "which singers were born before 1945? | select * from singer where birth_year < 1945 | how about after 1955?",
    "label": "CONFIRM_SQL",
    "output": "select * from singer where birth_year > 1955"
  },
  {
    "db_id": "singer",
    "input": "which singers born before 1945 have the same citizenship? | select * from singer where birth_year < 1945 | which singers born after 1955 have the same citizenship?",
    "label": "CONFIRM_SQL",
    "output": "select * from singer where birth_year > 1955"
  },
  {
    "db_id": "singer",
    "input": "which singers born before 1945 and after 1955 have the same citizenship? | Did you mean the singers born before 1945 OR after 1955? | what is the citizenship of the singers born before 1945?",
    "label": "CONFIRM_SQL",
    "output": "select citizenship from singer where birth_year < 1945"
  },
  {
    "db_id": "singer",
    "input": "and after 1955? | select citizenship from singer where birth_year < 1945 or birth_year > 1955 | Which singers with a citizenship of United States were born before 1945?\n",
    "label": "CONFIRM_SQL",
    "output": "select * from singer where birth_year < 1945 and citizenship = 'United States'"
  },
  {
    "db_id": "singer",
    "input": "and after 1955\n | select * from singer where birth_year < 1945 and citizenship = 'United States' union select * from singer where birth_year > 1955 and citizenship = 'United States' | Which singers with a citizenship of France were born before 1945?",
    "label": "CONFIRM_SQL",
    "output": "select * from singer where birth_year < 1945 and citizenship = 'France'"
  },
  {
    "db_id": "singer",
    "input": "and after 1955? | select * from singer where birth_year < 1945 and citizenship = 'France' union select * from singer where birth_year > 1955 and citizenship = 'France' | Which singers with a citizenship of Chile were born before 1945 or after 1955?",
    "label": "CONFIRM_SQL",
    "output": "select * from singer where birth_year < 1945 and citizenship = 'Chile' union select * from singer where birth_year > 1955 and citizenship = 'Chile'"
  },
  {
    "db_id": "world_1",
    "input": "how many country there | select count ( * ) from country | how many country languages there",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct language ) from countrylanguage"
  },
  {
    "db_id": "world_1",
    "input": "what is the surface area of code AFG | select surfacearea from country where code = 'AFG' | thanks",
    "label": "SORRY",
    "output": "welcome good bye"
  },
  {
    "db_id": "world_1",
    "input": "Hi, what is the population of the Caribbean?\n | select sum ( population ) from country where region = 'Caribbean' | What continents have an average life expectancy shorter than 72?\n",
    "label": "CONFIRM_SQL",
    "output": "select continent from country group by continent having avg ( lifeexpectancy ) < 72"
  },
  {
    "db_id": "world_1",
    "input": "Can you give me the total population for each of those continents? | select sum ( population ) , continent from country group by continent having avg ( lifeexpectancy ) < 72 | What is the average life expectancy of those continents?",
    "label": "CONFIRM_SQL",
    "output": "select avg ( lifeexpectancy ) , continent from country group by continent having avg ( lifeexpectancy ) < 72"
  },
  {
    "db_id": "world_1",
    "input": "Find the average life expectancy and total population for each continent where the average life expectancy is shorter than 72? | select sum ( population ) , avg ( lifeexpectancy ) , continent from country group by continent having avg ( lifeexpectancy ) < 72 | Thanks!",
    "label": "GOOD_BYE",
    "output": "Thank you. Goodbye."
  },
  {
    "db_id": "dog_kennels",
    "input": "Which street does  Nora Haley live? | select street from owners where first_name = 'Nora' and last_name = 'Haley' | What is her home phone number?",
    "label": "CONFIRM_SQL",
    "output": "select home_phone from owners where first_name = 'Nora' and last_name = 'Haley'"
  },
  {
    "db_id": "dog_kennels",
    "input": "What is the email address of Jaclyn? | Yes Jaclyn Stoltenberg | select email_address from owners where first_name = 'Jaclyn' and last_name = 'Stoltenberg'",
    "label": "INFORM_SQL",
    "output": "What is the first name of DuBuque?"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "What is the document id with least number of paragraphs? | select document_id from paragraphs group by document_id order by count ( * ) asc limit 1 | and the document with the most number of paragraphs?",
    "label": "CONFIRM_SQL",
    "output": "select document_id from paragraphs group by document_id order by count ( * ) desc limit 1"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "how many paragraphs are in that document with id of 2394? | select count ( paragraph_id ) from paragraphs where document_id = 2394 | What are the paragraph texts of those three paragraphs?",
    "label": "CONFIRM_SQL",
    "output": "select paragraph_text from paragraphs where document_id = 2394"
  },
  {
    "db_id": "dog_kennels",
    "input": "can you tell me the email id of the owner id ? | Do you mean all owner id and all email address? | owner id 1",
    "label": "CONFIRM_SQL",
    "output": "select email_address from owners where owner_id = 1"
  },
  {
    "db_id": "dog_kennels",
    "input": "what is the weight of dog id 1 ? | select weight from dogs where dog_id = 1 | Can you tell me age of dog id 1 ?",
    "label": "CONFIRM_SQL",
    "output": "select age from dogs where dog_id = 1"
  },
  {
    "db_id": "dog_kennels",
    "input": "Which owner has paid for the most treatments on his or her dogs ? List the owner id and last name. | select owners.owner_id , owners.last_name from owners join dogs on owners.owner_id = dogs.owner_id join treatments on dogs.dog_id = treatments.dog_id group by owners.owner_id order by count ( * ) desc limit 1 | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "wta_1",
    "input": "How many matches played in 2013? | select count ( * ) from matches where year = 2013 | How many matches played in 2016?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from matches where year = 2016"
  },
  {
    "db_id": "wta_1",
    "input": "What is the loser id  of petra kvitota? | Do  you mean \tloser  id | Yes",
    "label": "CONFIRM_SQL",
    "output": "select distinct loser_id from matches where loser_name = 'Petra Kvitova'"
  },
  {
    "db_id": "tvshow",
    "input": "which countries tv channels are not playing any cartoon written todd casey\n | select country from tv_channel except select tv_channel.country from tv_channel join cartoon on tv_channel.id = cartoon.channel where cartoon.written_by = 'Todd Casey' | who directed the cartoon the rise of blue beetle  written by Michael Jelenic\t?",
    "label": "CONFIRM_SQL",
    "output": "select directed_by from cartoon where title = 'The Rise of the Blue Beetle!' and written_by = 'Michael Jelenic'"
  },
  {
    "db_id": "tvshow",
    "input": "whats the package option for TV channels in itally? | select package_option from tv_channel where country = 'Italy' | thank you\n",
    "label": "GOOD_BYE",
    "output": "bye."
  },
  {
    "db_id": "concert_singer",
    "input": "Show the name and the release year of the song by the youngest singer | select song_name , song_release_year from singer order by age asc limit 1 | Ok. Can you show me the name and the release year of the song by the oldest singer",
    "label": "CONFIRM_SQL",
    "output": "select song_name , song_release_year from singer order by age desc limit 1"
  },
  {
    "db_id": "concert_singer",
    "input": "Can you also show me the name of the youngest singer | select name from singer order by age asc limit 1 | And what is the name of the oldest singer and his age",
    "label": "CONFIRM_SQL",
    "output": "select name , age from singer order by age desc limit 1"
  },
  {
    "db_id": "concert_singer",
    "input": "and what country was he from?\n | select country from singer order by age desc limit 1 | give me the names of the singers from United States\n",
    "label": "CONFIRM_SQL",
    "output": "select name from singer where country = 'United States'"
  },
  {
    "db_id": "pets_1",
    "input": "hi, what number of students have a dog as a pet? | select count ( * ) from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'dog' | and what about the number that have a cat as a pet?",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat'"
  },
  {
    "db_id": "pets_1",
    "input": "Great. Can you tell me the first names of these 3 students? | select distinct student.fname from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat' or pets.pettype = 'dog' | is there one more name?\n",
    "label": "CONFIRM_SQL",
    "output": "select distinct student.fname from student join has_pet on student.stuid = has_pet.stuid join pets on pets.petid = has_pet.petid where pets.pettype = 'cat' or pets.pettype = 'dog'"
  },
  {
    "db_id": "dog_kennels",
    "input": "Do any states have owners living there? | select state from owners | Which states have professionals living there?",
    "label": "CONFIRM_SQL",
    "output": "select state from professionals"
  },
  {
    "db_id": "dog_kennels",
    "input": "May I have a list of states that has both owners and professionals living there? | select state from owners intersect select state from professionals | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome."
  },
  {
    "db_id": "dog_kennels",
    "input": "List the first name of professionals | select distinct first_name from professionals | List the first name of professionals along with the description",
    "label": "CONFIRM_SQL",
    "output": "select distinct professionals.first_name , treatment_types.treatment_type_description from professionals join treatments on professionals.professional_id = treatments.professional_id join treatment_types on treatments.treatment_type_code = treatment_types.treatment_type_code"
  },
  {
    "db_id": "dog_kennels",
    "input": "List the first name of professionals along with the description of the treatment they have done? | select distinct professionals.first_name , treatment_types.treatment_type_description from professionals join treatments on professionals.professional_id = treatments.professional_id join treatment_types on treatments.treatment_type_code = treatment_types.treatment_type_code | Thanks!",
    "label": "WELCOME",
    "output": "You are welcome!"
  },
  {
    "db_id": "course_teach",
    "input": "how many course id numbers | select count ( course_id ) from course | what are the courses",
    "label": "CONFIRM_SQL",
    "output": "select course from course"
  },
  {
    "db_id": "course_teach",
    "input": "great, how many teachers available to conduct the course | select count ( teacher_id ) from teacher | which teacher takes math class",
    "label": "CONFIRM_SQL",
    "output": "select teacher.name from course_arrange join course on course_arrange.course_id = course.course_id join teacher on course_arrange.teacher_id = teacher.teacher_id where course.course = 'Math'"
  },
  {
    "db_id": "car_1",
    "input": "Can you list how many car makers are on each continent please? | Do you want the name of the continent and the count of car makers on each of them? | Yes please, in a table if possible?",
    "label": "CONFIRM_SQL",
    "output": "select continents.continent , count ( * ) from continents join countries on continents.contid = countries.continent join car_makers on countries.countryid = car_makers.country group by continents.continent"
  },
  {
    "db_id": "car_1",
    "input": "Can you list the full name and country of every car maker from asia? | Do you want the full name and country name of the car makers from asia? | Yes please",
    "label": "CONFIRM_SQL",
    "output": "select car_makers.fullname , countries.countryname from continents join countries on continents.contid = countries.continent join car_makers on countries.countryid = car_makers.country where continents.continent = 'asia'"
  },
  {
    "db_id": "car_1",
    "input": "What about from Europe? | select car_makers.fullname , countries.countryname from continents join countries on continents.contid = countries.continent join car_makers on countries.countryid = car_makers.country where continents.continent = 'europe' | How about America?",
    "label": "CONFIRM_SQL",
    "output": "select car_makers.fullname , countries.countryname from continents join countries on continents.contid = countries.continent join car_makers on countries.countryid = car_makers.country where continents.continent = 'america'"
  },
  {
    "db_id": "car_1",
    "input": "How many car makers are there total? | select count ( * ) from car_makers | Thanks!",
    "label": "GOOD_BYE",
    "output": "bye."
  },
  {
    "db_id": "dog_kennels",
    "input": "Hi there! Can you tell me how many different professional IDs are on this list? | select count ( distinct professional_id ) from professionals | Great!  Could you update this list to include both the first names and treatment type codes for each of these professionals IDs?",
    "label": "CLARIFY",
    "output": "Do you want the ids, first name for all professionals, along with the type codes of the treatment they have done?"
  },
  {
    "db_id": "dog_kennels",
    "input": "Yes please! | select professionals.professional_id , professionals.first_name , treatment_types.treatment_type_code from professionals join treatments on professionals.professional_id = treatments.professional_id join treatment_types on treatments.treatment_type_code = treatment_types.treatment_type_code | Excellent!  Can you filter this list to show me just the entries for the 5 most recent treatments?",
    "label": "CONFIRM_SQL",
    "output": "select professionals.professional_id , professionals.first_name , treatment_types.treatment_type_code from professionals join treatments on professionals.professional_id = treatments.professional_id join treatment_types on treatments.treatment_type_code = treatment_types.treatment_type_code order by treatments.date_of_treatment desc limit 5"
  },
  {
    "db_id": "battle_death",
    "input": "Show the names of all the battles.  | select name from battle | Show the names of all the battles and their Bulgarian commanders.",
    "label": "CONFIRM_SQL",
    "output": "select name , bulgarian_commander from battle"
  },
  {
    "db_id": "battle_death",
    "input": "Show the names of all the battles with no ships lost in the English Channel. | select name from battle except select battle.name from battle join ship on battle.id = ship.lost_in_battle where ship.location = 'English Channel' | Show the names and results of all battles with no ships lost in the English channel.",
    "label": "CONFIRM_SQL",
    "output": "select name , result from battle except select battle.name , battle.result from battle join ship on battle.id = ship.lost_in_battle where ship.location = 'English Channel'"
  },
  {
    "db_id": "battle_death",
    "input": "Show the names,results, and Bulgarian commanders of all battles with no ships lost in the English channel.\n | select name , result , bulgarian_commander from battle except select battle.name , battle.result , battle.bulgarian_commander from battle join ship on battle.id = ship.lost_in_battle where ship.location = 'English Channel' | What are the dates of all the battles with the result of Bulgarian victory. ",
    "label": "CONFIRM_SQL",
    "output": "select date from battle where result = 'Bulgarian victory'"
  },
  {
    "db_id": "network_1",
    "input": "how many Likes there | select count ( * ) from likes | how many friends there",
    "label": "CONFIRM_SQL",
    "output": "select count ( * ) from friend"
  },
  {
    "db_id": "network_1",
    "input": "what is the  friend id of  1689 | Do you mean the id of students with friend id 1689? | yes sir\n",
    "label": "CONFIRM_SQL",
    "output": "select student_id from friend where friend_id = 1689"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "Show me the documents | select * from documents | Show me the documents using template",
    "label": "CONFIRM_SQL",
    "output": "select documents.* from documents join templates on documents.template_id = templates.template_id"
  },
  {
    "db_id": "cre_Doc_Template_Mgt",
    "input": "How many of them are using the template with code 'PPT'? | select count ( * ) from documents join templates on documents.template_id = templates.template_id where templates.template_type_code = 'PPT' | Thanks!",
    "label": "GOOD_BYE",
    "output": "goodbye."
  },
  {
    "db_id": "car_1",
    "input": "whats the average acceleration | select avg ( accelerate ) from cars_data | whats the average horse power",
    "label": "CONFIRM_SQL",
    "output": "select avg ( horsepower ) from cars_data"
  },
  {
    "db_id": "world_1",
    "input": "what are the official unique official language spoken in the country\n | In which country? | what are the unique official languages spoken that are found before 1930",
    "label": "CONFIRM_SQL",
    "output": "select count ( distinct countrylanguage.language ) from country join countrylanguage on country.code = countrylanguage.countrycode where indepyear < 1930 and countrylanguage.isofficial = 'T'"
  }
]